Count of selection in expression, unique value

[ugurarslan]

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

[sunny_talwar]

How about this

Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120', 'Due 120+'}>}[AMT USD])

[ugurarslan]

This didn't work unfortunately....

[sunny_talwar]

Is it giving error or giving 0 or null as output?

[ugurarslan]

It didnt give the correct result. Sorry.

[sunny_talwar]

You don't have to be sorry for anything . But if you really need help, can you try to elaborate on what might be going on?

[ugurarslan]

Hi Sunny,

I created the following new question for you:

3 count questions for financial purposes.

Thanks for helping me.

Ugur

[rangam_s]

Try this.

Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120', 'Due 120+'}>}[Seller ID])