4 Replies Latest reply: Mar 29, 2016 8:42 AM by PAUL YEO RSS

    Modify SET expression from YTD and Month Close.

    PAUL YEO

      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

       

       

      Paul