I have a form that has a number of user input fields.
At the bottom of the form I have a field which finds the total of these fields using @Sum
My question is, how can I have the user input fields be blank when a new document is created?
i.e. I don't want to have to put 0 as the default value for all these fields.
At the moment I am nearly there using this:
res:=@Sum(@TextToNumber(@Trim(@Text(basic_hours + basic_hours_1 + basic_hours_2 + basic_hours_3 + basic_hours_4 + basic_hours_5 +basic_hours_6))));
However, this obviously only displays the total when all fields have a value.
Is there any way around this problem?