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.


      May i know where go wrong ?