Nested aggregation in set analyses

[krissy_s]

Hi All

I would like to count the number of policies which have more than 4 vehicle claims against them, but do not know how to write this in a set expression.

So far I have written the following:

=if(Count(match([Risk Class],'Vehicle') and Count(distinct If (([Claim Reference] > 4),[Policy Number]))))

The resulting error message is: Nested aggregation not allowed.

Can someone please assist?

Many thanks!

[arulsettu]

Maybe like this

Count({<[Claim Reference] ={'> 4'},[Risk Class]={'Vehicle'}>}distinct [Policy Number])