13 Replies Latest reply: Jan 30, 2018 3:31 AM by Jon Erik Lindberg RSS

    Year plus one

    Jon Erik Lindberg

      I need to display a measure for "2010" as "2011", "2011" as "2012"....etc.

       

      I have tried this formula (with many variations):

       

      Sum({<Year={$(={Year}+1)} >}my_measure)

       

      but it returns with 0. I would greatly appreciate any assistance.