shuboarder
asked on
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(@T rim(@Text( basic_hour s + 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
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(@T
@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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yeah my bro is ....
^ | ^
__
__
ASKER