3 Replies Latest reply: Jun 23, 2016 1:14 AM by PAUL YEO RSS

    Why Amount)/Rate not allow when compute GP% ?

    PAUL YEO

      Hi All

       

       

      Below expression from table 2 okay :-

      Sum({<rEVENUE={rEVENUE}>}Amount)/Rate

       

       

      Below expression from Table 3 not okay :-

      (

      sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

      -

      sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

      )

      /sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

       

       

      May i ask why first expression allow to place /Rate after Amount) , and second expression not allow ?

       

       

      Paul