3 Replies Latest reply: Mar 22, 2012 9:54 AM by Hamish Imrie RSS

    Count based on a "Sum IF" - Set Analysis

    Hamish Imrie

      Hi,

       

      I am not sure if this is possible - I have search the Forum....

       

      I have the following statement that I want to expand

       

      =count({<CompanyResponseFlag={'1'}>} distinct  CompanyID)

       

       

      I need to change the "CompanyResponseFlag={'1'}" set analysis bit to include a sum if statement as following

       

      =count(   {<    IF SUM OF THE CompanyResponseFlag is greater than one     >}               distinct  CompanyID)

       

      Any help much appreciated

       

      H