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))));
@If(@IsError(res)=1;"";res)

However, this obviously only displays the total when all fields have a value.
Is there any way around this problem?

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

a:= 4;
b:= 10;
c:= "";
d:= 6;
@Sum(@TextToNumber(@Trim(@Text(a):@Text(b):@Text(c):@Text(d))))

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

From novice to tech pro — start learning today.