Dear all,
I have a aging balance (outstanding amounts) which looks like the following.
| Seller ID | Car Type | On Hold | Current | Due 1-30 | Due 31-60 | Due 61-90 | Due 91-120 | Due 120+ |
| 1456 | Opal | YES | $12.00 | $- | $345.00 | $- | $75.00 | $- |
| 3478 | Ferd | NO | $45.00 | $- | $566.00 | $664.00 | $- | $- |
| 478382 | Pirsche | NO | $- | $788.00 | $7.00 | $6,443.00 | $- | $97.00 |
| 48392874 | Opal | NO | $- | $9.00 | $8.00 | $67.00 | $7.00 | $- |
| 247487 | Opal | YES | $87.00 | $- | $99.00 | $8.00 | $- | $- |
| 47465 | Hunda | NO | $789.00 | $346.00 | $6.00 | $8.00 | $7.00 | $- |
| 3928094 | Pirsche | YES | $80.00 | $9.00 | $54.00 | $99.00 | $- | $9.00 |
| 278479874 | Opal | NO | $- | $8.00 | $6.00 | $7.00 | $89.00 | $56.00 |
The question which I want to answer is:
How many Seller ID from the Car Type: Opal have an overdue balance which is over 90 days due.
The result which I expect to see is 2 (please see below which seller ID. ) I want to see the total of the unique seller id's.
| Seller ID | Car Type | On Hold | Current | Due 1-30 | Due 31-60 | Due 61-90 | Due 91-120 | Due 120+ |
| 48392874 | Opal | NO | $- | $9.00 | $8.00 | $67.00 | $7.00 | $- |
| 278479874 | Opal | NO | $- | $8.00 | $6.00 | $7.00 | $89.00 | $56.00 |
The expression I write:
Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120'}+{'Due 120+'}>}[AMT USD]) doesn't give me the right answer.
Can you please help me what the right expression should be?
Thanks
Ugur
. But if you really need help, can you try to elaborate on what might be going on?
