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 ?

       

      Paul