16 Replies Latest reply: Oct 17, 2016 5:12 AM by Jim Chan RSS

    set analysis (max year and last year)



      There something wrong in expressions I made:


      This year sales amount:

          Sum({$<Year={$(=Max(Year))}>}[Sales Amount])

      Last year sales amount

          Sum({$<Year={$(=Max(Year)-1)}>}[Sales Amount])


      Sales amount is the same for both of them and it shouldn't be. And year is not max(year). Actually, this just gives a sum of all years or sum of selected year(s).


      There was ei trigger on sheet (on opening) where max(year) was automatically selected, but I removed that.


      What's wrong in the expressions?