2 Replies Latest reply: Mar 19, 2012 11:11 AM by Ali Razavi RSS

    Set Analysis to count where a field matches the value in another field

    Hamish Imrie

      Hi,

       

      =num(count({<CompanyID ={'$(v_Currently_Selected_CustomerID)'}>}distinct Sales_Records),'#,##0')

       

      As can be seen in the above, I am trying to use set analysis to count

      Sales Records

      Where the CompanyID is the same value as the CUSTOMERID (stored via a variable).

       

      I think this syntax is incorrect. Any help most appreciated.

       

      H