I'm creating a travel expense claim form which captures an employees total miles and parking in a pay period. This is done using calculated fields. This function works as intended.
There will be times when the form owner will have to edit it after it has been saved. In my testing, when I edit the form, all of the calculations resolve to zero's. The fields will only recalculate when I place my cursor in the form field and click out of it.
I've done a quick video to show what I'm talking about.
Any help is appreciated.
Solved! Go to Solution.
We had the same issue with one of the releases and it was bug and this issue was fixed in the new release. What version are you on? Probably an update to a latest release will help.
You can do a conditional calculation. If the field value is null then do the calculation, or get the data from the field.
If(IsNullOrEmpty (FldName), Sum(Control), FldName)