I have a number of fields that are being added up and displayed in a Total Field on a form. The Total Field is Computed and populates when I save/close the document.
I would like the Total Field to refresh with the current total as I enter each of the values into the fields. therefore show the Total on the form before I save/close it.
Field: Adj$ - Number - Editable
(@If(@IsNumber(Adj$);Adj$;0))
Field: Adj$_1 - Number - Editable
(@If(@IsNumber(Adj$_1);Adj$_1;0))
Field: Adj$_2 - Number - Editable
(@If(@IsNumber(Adj$_2);Adj$_2;0))
Total: AdjTotal - Number - Computed
@Sum(Adj$ ; Adj$_1 ; Adj$_2)