topic Re: count distinct if in Search the Community

count distinct if

tuncfiratvb — Thu, 11 Nov 2021 14:42:36 GMT

hi,

I have total_balance_ecl, total_balance_ecl_org and COUNTERPARTYID-MUSTERINO columns. I want to count COUNTERPARTYID-MUSTERINO of which total_balance_ecl not equal to total_balance_ecl column.

=count({<TOTAL_BALANCE_ECL<>{TOTAL_BALANCE_ECL_ORG}>}distinct [COUNTERPARTYID-MUSTERINO])

formula above doesnt work. thanks for any help in advance.

Re: count distinct if

abhijitnalekar — Fri, 12 Nov 2021 11:19:37 GMT

Hi @tuncfiratvb ,

Try below expression

=count({<TOTAL_BALANCE_ECL -= {TOTAL_BALANCE_ECL_ORG}>}distinct [COUNTERPARTYID-MUSTERINO])

Also If possible, please share the sample data or

You can create a flag at the script level and use the same flag in the set analysis.

eg.

you can create the below flag at the script level

If((TOTAL_BALANCE_ECL-TOTAL_BALANCE_ECL_ORG)-=0,1,0) as Flag

and use the same like below

=count({<Flag={'1'}>}distinct [COUNTERPARTYID-MUSTERINO])

Re: count distinct if

Venus1997 — Fri, 12 Nov 2021 12:36:52 GMT

=Count( {<COUNTERPARTYID-MUSTERINO = {"=TOTAL_BALANCE_ECL <> TOTAL_BALANCE_ECL_ORG"}>} COUNTERPARTYID-MUSTERINO)