Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Avg(Aggr(Count({$<DateSK=E({1<CSN={'0'}>})>}DISTINCT CSN),DateSK))
Avg(Aggr(Count({<DateSK={">0"}>}DISTINCT CSN), DateSK))
Thank you Peter. But this solution only exclude dates that equal 0, not the distinct count of CSN's on a given date.
Avg(Aggr(Count({$<DateSK=E({1<CSN={'0'}>})>}DISTINCT CSN),DateSK))
Thanks Peter!