5 Replies Latest reply: Jun 14, 2016 10:58 PM by Sunny Talwar RSS

    SET expression change from sum(sales) to rEVENUE return null

    PAUL YEO

       

      Hi All

       

       

       

       

      I have below expression work fine :-

      SUM(sales)

       

       

      I manage to conver to from sales field to rEVENUE , it work fine :-

      Sum(

      {<rEVENUE={rEVENUE}>}Amount

      )

       

       

       

       

      I also have below expression work fine :-

      sum(-sales*YearToDate(date, year-Year(Today())))/1000

       

       

       

       

      I try to convert it from sales to rEVENUE , it return null :-

      sum(-

      {<rEVENUE={rEVENUE}>}Amount

      *YearToDate(date, year-Year(Today())))/1000

       

       

      Can some one advise me where go wrong ?

       

       

      Paul