Nested aggregation not allowed using sum and if statement ( tried usingaggr)

aj_954 — Tue, 04 Jan 2022 22:50:50 GMT

Hi,

I am trying to sum the counts of a variable:

here is the code:

=sum(if(aggr([Requesting Agency] = 'JAY',count([Servicing Agency])),1))

but I am getting an error. I want to count the total number of times of the servicing agency being a value when the requesting agency = jay.

Re: Nested aggregation not allowed using sum and if statement ( tried usingaggr)

rwunderlich — Tue, 04 Jan 2022 22:55:31 GMT

count({<[Requesting Agency]={'JAY'}>}[Servicing Agency])