3 Replies Latest reply: Jun 21, 2016 5:53 PM by PAUL YEO RSS

    Why i cannot divide by Rate in my GP% Expression ?

    PAUL YEO

      Hi All

       

      I have below expression it alway display 0 % when i select SOURCE = TDSID :-

       

      (

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

      -

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

      )

      /

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



      After i remove the /Rate as below , And it work fine :-


       

      (

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

      -

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

      )

      /

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


      My question is why i need to remove /Rate to make it work ? as logically it is a constants , so it should not affect the result. but it does .


      Paul