How do I setup duplicated fields to calculate the correct field numbers?

  • Profile Image
    Asked on October 09, 2016 at 07:21 PM

    I created a mileage report, initially with 15 days worth of entries.  I've now added an additional 15 days.  The initial 15 days entries are subtracting and totaling correctly.  However, I duplicated the next 15 and now they aren't calculating correctly and when I check in the wizard the field numbers are off as well.  How can I fix this?  Please help!

  • Profile Image
    Answered on October 09, 2016 at 09:29 PM

    Since the fields were duplicated from one of the original fields, the calculations for the next 15 are being based on the entries from the original field, and not their own fields. To resolve this issue, you will have to remove the current formula on the new 15 fields and update it with the correct fields.

    Once you update the formula for each of the new 15 fields, the calculations should now be correct.

    If you need further assistance, please let us know.