1 Reply Latest reply on Jan 3, 2017 7:32 AM by Norbert Maijoor

    sum of 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.