7 Replies Latest reply: Dec 8, 2016 12:11 PM by Jim King RSS

    Conditioning a set analysis

    Jim King

      Is there a way to test the result of the following and zero out the result if it comes back negative?

       

      SUM({<IDPAGR={'PART','MECH','OCSE','COOL','CAFE'}>}Gross) / sum({<IDPAGR={'PART','MECH','OCSE','COOL','CAFE'}>}Amount)

       

      Thanks in advance