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 ?

    PAUL YEO

      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 ?

       

       

      Sum(if(LY_YTD,sales))

       

       

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

       

       

       

       

      Paul