I'm trying to figure out how to calculate counts on indirect references (Application > Vulnerability Tickets > Vulnerability Scan Results by Severity).
I'm looking to house these formulas on the Application or maybe even on an ODA that will have a reference to an application, which extends the path further.
I can calculate these from the Vulnerability Tickets easily enough like so: COUNTIF(REF([Vulnerability Scan Results],[Severity]), VALUEOF(REF([Vulnerability Scan Results],[Severity]),"Critical"))
This being said, I'm not sure what it would look like to get the SUM of the counts from the top level.
The other alternative that I was looking at is to add interim fields at each level.