Expression to Get Count with a condition

sqlpuzzle — Mon, 03 Jul 2017 21:35:44 GMT

Hello,

In a sample scenario I have the above table.

AccountId's in both Countries are 2,3,4,6.

I need an expression that would count the distinct AccountId's that exist in both countries.

In this case I am expecting 4 as four of them (2,3,4,6 exists in both countries)

How can I get this done?

Re: Expression to Get Count with a condition

antoniotiman — Tue, 04 Jul 2017 03:59:32 GMT

Hi Joe,

=Count({<AccountId={'=Count(DISTINCT Country) > 1'}>} DISTINCT AccountId) -> 4

=Concat({<AccountId={'=Count(DISTINCT Country) > 1'}>} DISTINCT AccountId,';') -> 2;3;4;6

Regards,

Antonio