Using @Sum to calculate form field totals

Hi all,

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?

LVL 21
Who is Participating?
p_parthaConnect With a Mentor Commented:
Wonderful tip from sjef:

a:= 4;
b:= 10;
c:= "";
d:= 6;

shuboarderAuthor Commented:
That Sjef is a clever chap ;)
Yeah my bro is ....
Sjef BosmanGroupware ConsultantCommented:
^ | ^
All Courses

From novice to tech pro — start learning today.