1 Reply Latest reply: Jul 3, 2017 11:59 PM by Antonio Mancini RSS

    Expression to Get Count with a condition

    Joe Mathews
      AccountIdCountry
      1USA
      2USA
      3USA
      4USA
      5USA
      6USA
      7USA
      8USA
      2CAN
      2CAN
      3CAN
      4CAN
      6CAN
      6CAN
      5USA
      9CAN

       

      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?