AGGR Set Analysis

[Taylorcc]

Hello, 

How can I change the following to count referral numbers that have a null K10 difference? 

COUNT( IF(AGGR($(K10 Difference),OMReferralNumber)<=0 OR AGGR($(K10 Difference),ReferralNumber)>0,1))

Thank you

[rubenmarin · Accepted solution]

Hi, maybe with: COUNT(AGGR(If(IsNull($(K10 Difference)),OMReferralNumber),OMReferralNumber))

Or: Sum(Aggr(If(IsNull($(K10 Difference)),1),OMReferralNumber))

[Taylorcc]

Thanks Ruben, 

The first option is working 🙂 How do I convert this to show the referral numbers in a table? 

(I would like just one column with referral numbers, not one column with referral numbers and a second with 1 or 0 if the difference is null)

Thanks again 

[rubenmarin]

Hi, you can try to create a dimesnion with this:

Aggr(If(IsNull($(K10 Difference)),OMReferralNumber),OMReferralNumber)