3 Replies Latest reply: Sep 22, 2016 11:15 PM by PAUL YEO RSS

    How to modify SET expression so that even now is Sept 2016 it will take in date 1 Dec 2016 ?

    PAUL YEO

      Hi All

       

       

      i have below SET expression working fine :-

       

       

      =Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)

       

       

      When user select OMRON_1 , TEXT 1 Display zero.

       

       

      The reasons why user click on OMRON_! it display zero because the date is 1 Dec 2016 or 1 Dec 2015 and so on.In order to make it display , i need to select year = 2015. ( To make it work , i have change the date from 2016 to 2015 , which is not correct. )

       

       

      How to make it display 12621000 when user select OMRON_1 ? by change the SET expression ?

       

       

      Remark :- When user click on OMRON , it display 12821000.( Because i have replace 2016 to 2015 , which is not correct ).

       

      I am at china now , unable to upload the QVW file

       

       

      Paul