Aggr exclude zero results

[cfountain72]

Hello, 

I am using the AGGR function, but want to exclude values where the results of the calculation is zero.

=avg(aggr(count(distinct CSN), DateSK))

So, for DateSK's that have 0 CSN's, I want them to be excluded from the aggregation.

Any suggestions?

Thanks in advance,

Chris

[BrunPierre]

Avg(Aggr(Count({<DateSK={">0"}>}DISTINCT CSN), DateSK))

[cfountain72]

Thank you Peter. But this solution only exclude dates that equal 0, not the distinct count of CSN's on a given date.

[BrunPierre · Accepted solution]

Avg(Aggr(Count({$<DateSK=E({1<CSN={'0'}>})>}DISTINCT CSN),DateSK))

[cfountain72]

Thanks Peter!