7 Replies Latest reply: Jun 18, 2018 5:50 AM by Rangam Seshadri

# Count of selection in expression, unique value

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

• ###### Re: Count of selection in expression, unique value

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

• ###### Re: Count of selection in expression, unique value

This didn't work unfortunately....

• ###### Re: Count of selection in expression, unique value

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

• ###### Re: Count of selection in expression, unique value

It didnt give the correct result. Sorry.

• ###### Re: Count of selection in expression, unique value

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?

• ###### Re: Count of selection in expression, unique value

Hi Sunny,

I created the following new question for you:

3 count questions for financial purposes.

Thanks for helping me.

Ugur

• ###### Re: Count of selection in expression, unique value

Try this.

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