4 Replies Latest reply: May 25, 2016 7:09 PM by PAUL YEO RSS

    How to change the meansure from sales to rEVENUE in SET expression?

    PAUL YEO

      Hi All

       

      My Chart 1 Expression as below  working fine :-

       

       

      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-1)}

      ,

      month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}

      >} sales/$(Columndim89)/1000)

       

       

      Now i like to replace sales with nET_PROFIT as below :-

       

       

      Sum({<nET_PROFIT={"nET_PROFIT"}>}Amount)

       

       

      I try below expression in chart 2 :-

       

       

      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-1)}

      ,

      month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}

      >} ({<nET_PROFIT={"nET_PROFIT"}>}Amount)/$(Columndim89)/1000)

       

       

      it does not work.

       

       

      Paul