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

    set analysis (max year and last year)

    Ville Syrjänen

      Hi,

       

      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?