I need to count an ID if the sum of other fields for that ID are both > 0.
I can easily do this in a table by making a table grouped by ID, and filtering for field A and field B to be > 0. Then I get a total at the bottom of the table of the number of IDs there.
However, if I try to do the equivalent logic in a calculated field: countIf(ID, sum(field A) > 0 and sum(field B) > 0), I get an error that I can’t nest aggregate functions.
How can I make a calculated field with the same behavior as the table totals?