<div>
That Sjef is a clever chap ;)
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have a form that has a number of user input fields.<br />
At the bottom of the form I have a field which finds the total of these fields using @Sum<br />
<br />
My question is, how can I have the user input fields be blank when a new document is created?<br />
i.e. I don't want to have to put 0 as the default value for all these fields.<br />
<br />
At the moment I am nearly there using this:<br />
<br />
res:=@Sum(@TextToNumber(@T<wbr />rim(@Text(<wbr />basic_hour<wbr />s + basic_hours_1 + basic_hours_2 + basic_hours_3 + basic_hours_4 + basic_hours_5 +basic_hours_6))));<br />
@If(@IsError(res)=1;&quot;&quot;;res<wbr />)<br />
<br />
However, this obviously only displays the total when all fields have a value.<br />
Is there any way around this problem?<br />
<br />
Thanks
</div>
</div>


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

Using @Sum to calculate form field totals

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.