2 Replies Latest reply: Mar 3, 2016 6:07 PM by PAUL YEO RSS

    How to modify the expression So that it still work when current month and year not selected


      Hi All



      I have below expression working fine ( Ref to chart 1 ) , when year = 16 and month = 3 :-



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



      May i know how to change the above expression still working , when year and month is not selected. So that i can use the same expression in QS. with out need to activate current month and current year.