3 Replies Latest reply: Jun 20, 2016 4:10 AM by Yeo Poh sai RSS

    sum({$<YTD = {1} , rEVENUE={rEVENUE}>}Amount)/Rate return Null , How to make it display 158,000 ?

    Yeo Poh sai

      Hi All

       

       

      I have below expression return correct value :-

      Sum (if(YTD,sales/Rate))

       

       

       

       

      I try to convert from sales to rEVENUE as below :-

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

       

       

       

       

      But the above expression return null value , It should be around 158,000

       

       

      Hope some one can advise me.

       

       

      Paul