4 Replies Latest reply on Jan 5, 2017 1:31 AM by Norbert Maijoor

    how to find difference betwwen two months

    vidya k

      hi everyone,

       

            In my project I need to find the difference or sum of two continue months. For the difference I used the formula as

      ZN(SUM([Sales Forecast])) - LOOKUP(ZN(SUM([Sales Forecast])), -1)

      And now the requirement for February month  need to print the result as "((January - December )+( February-January))" ,

      For march month is   "((January - December )+( February-January)+(March-February)))" ,.... up to December.

       

      Please any one help for solve these problem.

       

       

       

      Thanks,

      Vidya