5 Replies Latest reply: Mar 15, 2016 5:46 AM by Sunny Talwar RSS

    When current year and month is not selected , how to compute LY YTD sales ?

    Yeo Poh sai

      Hi All



      Table 1 is my SET expression need to select the current month and year.



      sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales/1000)





      Now i can only achieve using , Flag , may i know how to make use of SET ?






      May i know how to modify the above expression so that i don't need to select current year and month ?