3 Replies Latest reply: Nov 2, 2016 4:49 AM by Tresesco B RSS

    How to sum with multiple fields with analysis?

    Louis Lam

      Hi all,

       

      I would like to add analysis to below expression,

      Sum(SALES_QUANT*SALES_COST)

       

      Is it possible to sum with multiple fields with analysis? like below example,

       

      Sum(({$<[Field A] = {">0"}, [Field B] = "123">}SALES_QUANT)*({$<[Field C] = {">10"}, [Field D] = "456">}SALES_COST))

       

      Best Regards,

      Louis