Zero and Null in Calculations

You can try

if (sum(field1,field2,field3) eq 0) ""
else
sum(field1,field2,field3)
endif

This sets the field value to "" when zero. Another approach would be to hide the field.

Thank you George.

I have

if (sum(field1,field2) eq 0) ""
else
sum(field1,field2)
endif

as you suggested but I receive the following alert:

Error: syntax error near token "" on line 1 column 31.

Have I missed something or copied something incorrectly?

That might not work in FormCalc, I do not have an available copy right now. It does work in Acorbat forms. You could also allow the field to display zero and make the presence "invisible"

sum(field1,field2)
if ($.rawValue eq 0)
$.presence = "invisible"
else
$.presence = "visible"
endif

A search turned up:

http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=6563

I very much appreciate your help.

Actually I prefer using Acrobat Forms to LifeCycle.

I tried the script

if (sum(field1,field2) eq 0) ""
else
sum(field1,field2)
endif

In Acrobat and received the error message

Missing ) after condition 1: at line 2

Getting closer!

Acrobat JavaScript's syntax is different, but the "null" vaue may still need to be used and since you have only 3 fields to sum:

// JavaScript in the Calculation event
// Sum of fields
this.rawValue = Field3.rawValue + Field2.rawValue + Field1.rawValue;
if(this.rawValue == 0)
this.rawValue = null;

This script works perfectly in LifeCycle Designer.

Many thanks for your persistence.

Howard