4 Replies Latest reply on May 19, 2017 5:42 AM by mikebeargie

    Calculation based on two value from different records in the same table

    danjherbert

      I'm looking to perform a calculation where in the table a record is created each week, I want to calculate the difference in value between two values where the date is one week later

       

      E.g. date is Monday last week in record A and date is Monday this week in record B, I want value B to minus value A