2 Replies Latest reply: Mar 3, 2016 6:07 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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.