3 Replies Latest reply: Feb 21, 2018 12:15 AM by P M RSS

    SET expression after change to IF expression give wrong result

    Yeo Poh sai

      Hi All


      Below expression work fine :-

      Sum(Aggr(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1), GROUP_TYPE))


      when I change the above expression to below , it return wrong result.

      Sum(if(Year_n<'2',sales/Rate,GROUP_TYPE))


      May i know where go wrong ?


      Paul