9 Replies Latest reply: Jan 9, 2013 4:41 AM by barnabe42 RSS

    Can't make =Only([YEAR]-1) working in the expression definition

      I am trying to display the cumulative sales for the current and previous year

       

      In the label the expression "=Only([YEAR]-1)" seems to works correclty as show in the screenshot

       

      But I can't make the expression "=sum( {$<Year = {$(=Only([YEAR]-1))}>} AMOUNT ) " working, it always evaluate the current year.

      Am I doing anything wrong ?

      /Eric