Solved

# acrobat defaults to 0.00 in sum field

Posted on 2013-06-18
776 Views
Hi - I'm calculating a SUM from 2 fields - but acrobat is insisting on writing 0.00 as default. I don't see any way to change that behaviour, without deselecting the "sum" radio button and using custom script. Or did I miss something?. Is there an easy script that does both the sum command and a null command?
Maybe something that would add to this?
if(event.value == 0) event.value = "";
0
Question by:seanpowell
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 44

Accepted Solution

Karl Heinz Kremer earned 500 total points
ID: 39259252
Unfortunately, there is no easy solution for this.

You want two different things:
Format the number with two decimals
Hide the output if the result is 0.

In order to combine both, you have to write a script. Open up the properties for your sum field and go to the Format tab, then select a "Custom" formatting and enter the following as the custom format script:

``````if (event.value == 0)
event.value = "";
else
event.value = parseFloat(Math.round(event.value * 100) / 100).toFixed(2);
``````

The condition for the if statement tests if the value is zero, if it's not, then the "else" branch converts the numeric result of the calculation to a number with two decimals.

... and, just in case it's not clear, we are not changing how you calculate the sum, so that stays the same on the "Calculate" tab. The result of the calculation is still 0.00, but we are not displaying that value. If you would use the value of the Sum field in another calculation, the value used would be 0.00 in this case.
0

LVL 31

Author Closing Comment

ID: 39259327
Solutions don't get much better than that. Thanks khkremer :-)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question