2 Replies Latest reply: Jun 5, 2018 3:25 PM by Sunny Talwar RSS

    Calculate Field Value Previous Month

    Agustin Moreno

      Hello! I'm trying to calculate a field value for the previous month in a new column of the same table but I'm not able...

       

      My table looks like this:

       

      Captura.PNG

      The field TOTAL_EUROS_MES_ANTERIOR should be the value of the total amount of sales in the previous month. For example, for year 2017, period 10 it should value 42443

       

      Thanks a lot for your help.
      Regards