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

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

    Yeo Poh sai


      Hi All





      I have below expression work fine :-




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








      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 :-



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



      Can some one advise me where go wrong ?