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

    Count based on a "Sum IF" - Set Analysis

    Hamish Imrie



      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