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