How do I correct this? I am using two calculated fields in another calculation. With the example shown below, if I change Field2, Field9 doesn't recalculate.
Field1
Field2
Field3
Field4 = Field 1 + Field 2 + Field 3
Field5
Field6
Field7
Field8 = Field 5 + Field 6 + Field 7
Field9 = Field4 + Field8
Thanks!
If you are using the Simplified field notation, then you only need to enter:
Field 1 + Field 2 + Field 3
In for the field where you want to sum the fields 1-3.
You may also see a problem where the fields are not calculated in the correct order. This will result in a computed answer showing up for the previous values when a new value is entered into a new field. In this case, you will need to edit the field calculation order for the form.
George Kaiser