danjherbert

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

Discussion created by danjherbert on May 18, 2017
Latest reply on May 19, 2017 by mikebeargie

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

Outcomes