Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
please see the table as following:
Aging Bucket | ||||
Company ID | 1-60 | 61-90 | 90 - 120 | 120+ |
Apple | $13 | $50 | $6 | |
Peer | $8 | $9 | $150 | $50 |
Banana | $5 | $9 | ||
PineApple | $5 | |||
Bag | $7 | $8 | $8 | |
Table | $3 |
Dimension = Aging Bucket.
If I want to count how many company ID's have an overdue balance of 90 days I write this expression:
Count({<[Aging Bucket]={'90-120'}+{'120+'}>}distinct [Company ID]) |
Result = 6
But the result needs to be 4 Companies have an item on 90+.
Can you please help me writing the right expression?
Thanks
Ugur
Hi Ugur,
Please try like below.
Count({<[Aging Bucket]={'90-120','120+'}>}distinct [Company ID])
This will work for you.
Regards,
Akshaya
PS - If you find response Correct/Helpful then mark it as Correct/Helpful.