Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression that works: count({$<TotalCharges={'>0'}>} DISTINCT Customer_ID)
The only problem is, there are possible occurrences where the TotalCharges for a Customer_ID is posted and then backed out of the system by posting a negative. Because of this, I'd like to count only the distinct Customer_IDs that have net positive TotalCharges.
I have attempted:
sum(aggr(count({$<TotalCharges={'>0'}>} DISTINCT Customer_ID),AcctPeriod))
where AcctPeriod is my only dimension in the chart, with no avail.
Any help is greatly appreciated, I'm obviously novice trying to pick up on things as quick as possible.
Hi John,
Did you try?
Count({< TotalCharges = {"=Sum(TotalCharges) > 0"} >} DISTINCT Customer_ID)
Miguel
Hi John,
Did you try?
Count({< TotalCharges = {"=Sum(TotalCharges) > 0"} >} DISTINCT Customer_ID)
Miguel
Thank you so much Miguel! I am fairly certain this is correct, will vet it and reply if otherwise.
John