I have a form that calculates the total miles when a user enters the Trip Odometer Readings.
Once the user has entered multiple trips, I sum up the total miles and multiply it by a mileage rate providing me a reimbursement amount.
The problem occurs when the submitter fills out the form and sends it to an approver. The approver receives the "read-only" submission form and rejects it. The approver requires the user to remove a table row because the trip didn't occur in that pay period.
When the user receives the form back, they delete the row and submit the form. We are able to see the sum of the total miles update before they submit the form.
When the approver receives the corrected form, the sum of the total miles is the previous value before the row was deleted.
I was able to recreate the issue. I am on Forms Version 10.2.1.205
Please see below.
Calculation for Table 1 - Total Miles Field
=IF(SUM(INDEX(mileage_odometer.End_Odometer,ROW()),0)>0,SUM(SUM(INDEX(mileage_odometer.End_Odometer,ROW()),0.00),-SUM(INDEX(mileage_odometer.Begin_Odometer,ROW()),0.00)),0.00)
Calculation for Table 2 - Reimbursement Field
=PRODUCT(summary.Total_Miles,summary.Milage_Rate)
The Approver rejects the form and the submitter removes the 4th row.
Once the submitter resubmits the form, the summary does not change.