Solved

acrobat defaults to 0.00 in sum field

Posted on 2013-06-18
2
707 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
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);

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
ID: 39259327
Solutions don't get much better than that. Thanks khkremer :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

PaperPort is a popular document imaging/management product from Nuance Communications (http://www.nuance.com/). It is in widespread use by both individuals (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) and businesses (http:/…
PDF files have been in the limelight due to its unmatched features.  Personal documents, emails, business reports and eBooks are all converted into PDF files owing to peerless features provided by it. Adding watermark to a PDF file is a method to se…
In this second video of the Xpdf series, we discuss and demonstrate the PDFimages utility, which, in a single command, is able to extract all the images from a PDF file and save each one in a separate image file (PBM, PPM, or JPG). Download and inst…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

863 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

21 Experts available now in Live!

Get 1:1 Help Now