10 Replies Latest reply: Sep 2, 2016 3:37 AM by Yeo Poh sai RSS

    Why my SET expression must select year=2014 then it can work ?

    Yeo Poh sai

      Hi All


      My set expression as below :-


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


      When i not select any year , it should be able display the latest sales amount.


      But it does not work like above , i need to select year=2014 , then it able to display the amount .


      May i know where go wrong ?