3 Replies Latest reply: Nov 6, 2017 8:34 AM by Stefan Wühl RSS

    How to write set analysis for IF function?

    Lim Siew Mei

      I had set expression for IF function. How can i convert it to set analysis?

       

      example:

      If(ONTARGET_LATEST_SNAPSHOT='Y', sum(SALES_EOQ/2000), if(ONTARGET_LATEST_SNAPSHOT='N', sum(SALES_EOQ/1000)))