4 Replies Latest reply on Apr 25, 2018 5:19 AM by Ruta Cerniauskaite

    Calculating the difference

    Ruta Cerniauskaite

      Hi All,

       

      I have got a problem.

       

      I have data of MAT(Moving annual total) and MAT-1. This data is not connected to date and it is a STRING. It is connected to the Sales Period Group ID which would be 'MAT'

      I need to display this data, which I can do it without complications, but then I need to find a difference between (MAT-1)-MAT=??

       

      Since it is not directly connected to date, I cannot use MAX(Sales period ID) since that table has over a 100 different values.

       

      Please see image attached

       

      So I am lost.

       

      Could somebody help me please?

       

      Best Regards,

       

      Ruta Cerniauskaite