Solved

acrobat defaults to 0.00 in sum field

Posted on 2013-06-18
2
634 Views
Last Modified: 2013-06-19
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?acrobat issue. 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
Comment
Question by:seanpowell
2 Comments
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 500 total points
Comment Utility
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);

Open in new window


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

by:seanpowell
Comment Utility
Solutions don't get much better than that. Thanks khkremer :-)
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

*Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions. 1. Create a framework of your form in Word, leaving space where you’d ultimately like the Adobe fields to appear.  (Note: I use the blank lines …
This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
In this video, we show how to perform Bates Numbering/Stamping of PDF documents using Power PDF Advanced, the newest product from the Document Imaging division of Nuance Communications. There are two editions of Power PDF — Standard and Advanced. Th…
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now