3 Replies Latest reply: Apr 13, 2016 3:44 AM by PAUL YEO RSS

    why add sum(aggr into expression it return null value ?

    PAUL YEO

      Hi All

       

      I have below expression work fine :-

       

      Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000

       

      I try to add sum(aggr into above expression :-

       

      sum(aggr(

      Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000

      ))

       

      it display null value.

       

      Paul