Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Contributor III

AGGR Set Analysis

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

Labels (2)

• General Question

1 Solution

Accepted Solutions
MVP

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

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

3 Replies
MVP

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

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

Contributor III
Author

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

MVP

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

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

Tags
Community Browser