3 Replies Latest reply: Apr 27, 2016 9:34 PM by PAUL YEO RSS

    Can Sunny SET expression be modify to make it more dynamic ?

    PAUL YEO

      Hi All

       

      I have got this SET expression from Mr sunny :-


      Money(RangeSum(
      Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
      -Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
      , $(vMoneyFormatK_GL))

       

      My question is , it is possible to modify to change the above expression to make it more dynamic. So when user not select any date it will display current month and year amount.

       

      If user click on year=2015 , month = march. The above above amount will change to Last year same period amount.

       

      Paul