6 Replies Latest reply on Jun 12, 2018 12:32 PM by Hari Ankem

    Previous year calculation

    Krishna Dudhela

      Hi Everyone,

       

      My report contains many columns. Like below

       

       

      I have a year filter. I am trying to calculate the previous year value

       

       

      To calculate the previous year value I used the below formula

       

      and it skips the first value

       

       

      Can anyone help me fix this? I checked multiple solutions on the forum but it doesn't align with my entire report. It requires to create a parameter.

       

       

      Your help is appreciated.

       

      Thanks,

      Krish.