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



      =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.