11 Replies Latest reply: Apr 13, 2016 12:31 AM by PAUL YEO RSS

    GP% measure  , may i know how to make it display 19.5% ?

    PAUL YEO

      Hi All

       

      I have below expression , it return 0.00 on GP% measure  , may i know how to make it display 19.5% ?

       

      Hi All

       

      I have below expression :-

       

      (
      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000
      -
      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, cOST={"cOST"} >} Amount*-1)/Rate/1000
      )
      /
      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000

       

       

       

      May i know how to make it display 19.5% ? now it display 0.00

       

      Paul