4 Replies Latest reply: Mar 29, 2016 8:42 AM by Yeo Poh sai RSS

    Modify SET expression from YTD and Month Close.

    Yeo Poh sai

      Hi All



      I have below expression , it will return YTD sales :-



      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)



      Now i need to modify the above expression to display month closed. Meaning only display Jan and Feb sales amount exclude march sales amount.



      So the result should only shown 1461