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

    PAUL YEO

      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.

       

       

      Paul