6 Replies Latest reply: Mar 12, 2018 4:10 AM by Manish Kachhia RSS

    =num(Sum({$< Month_n  ={"1"}>} sales/1000)/Rate) How to convert to SET expression

    Yeo Poh sai

      Hi All


      I have this expression work fine :-


      =num(Sum({$< Month_n  ={"1"}>} sales/1000)/Rate)


      Can some SET expert here help me convert to using SET expression. So that i dont need to use the additional field on Month_n


      Remark :- Below expression is YTD work fine :-


      =num(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000))



      Paul