6 Replies Latest reply: Nov 12, 2012 12:01 PM by daniele zanoni RSS

    use inputfield of previous month

      i have this situation:

       

      inputfield A

      LOAD * INLINE [

          YYYY,M, A

          2012,2, 20

          2012,3, 30

          2012,4, 40

          2012,5, 50

      ];

       

       

      i need to use in a formula the value of the inputfiled A of the previous month compared to the month in column

       

      example table :

      month          inputvalue     value

      3                 30               20

      4                 40               30

      5                 50               40

       

      if I change the value of the inputfield for month 4 to 111 i need to see this value in the column of month 5

      if I select a month the formula must work, so i cant use before or previous functions

      in the attachment a qv doc that recreate the example

       

      is it even possible?, thanks.

      d.