5 Replies Latest reply: Mar 24, 2014 11:52 PM by Ruchi Bagaria RSS

    How to use if stmt within sum function in set analysis?

    Ruchi Bagaria

      I need the foll:

      Fyear

      GROUP_DESC

      Amount

      FY13

      Net sales

      2343

       

      Profit

      12%

      FY12

      Net sales

      3452

       

      Profit

      23%

      I am using Set analysis something like foll which is having four diff expressions and giving me four columns in the table:

       

      sum({<GROUP_DESC={'Net sales'},FYear={$(vPrevFY)}>}Amount)/1000000

      sum({<GROUP_DESC={'Net sales'},FYear={$(vCurrFY)}>}Amount)/1000000

      sum({<GROUP_DESC={'Profit'},FYear={$(vPrevFY)}>}Amount)/1000000

      sum({<GROUP_DESC={'Profit'},FYear={$(vCurrFY)}>}Amount)/1000000

       

      how can i get all these four in one condition so that i get only one column using if stmt?