0 Replies Latest reply on May 9, 2017 7:34 AM by danjherbert

    Value between two records of the same table

    danjherbert

      I have a table where I want to calculate the value between two records, where the field 1 - field 2 gives me the result in field total

       

      The table is made up of the following fields

       

      id = unique / auto-enter

      date = date of the Monday of the week

      mon_gross = number

      fri_gross = number

      total = calc

       

      each week a record is created and the Monday and Friday values are entered, I want the total to show the difference between the Friday of the previous week and the Monday of that week