Total of a sum to return a blank value rather than zero

Are you creating your form using Acrobat Forms or LiveCycle Designer?

If you are using Acrobat Forms, you can use the following JavaScript as a custom validation script for the sum field:

if (event.value == 0) event.value = "";

This will always supress the dispaly of zero.

Have you read Ted Padova's 101 Tips and comments?

If you have used LiveCycle Designer, you can set the presence property for the result field.

if (NumericField1 > 0) then
$.presence = "visible";
NumericField1 * 10;
else
$.presence = "invisible";
0;
endif

http://forms.stefcameron.com/2006/05/15/calculate-scripts/

Hi

Thanks for this. I am using Acrobat Forms.

I put your code in the custom validation script for the sum field and this has not worked?

Should it be in the custom calculation script instead? If so, how do I manually script the sum and your code?

Thanks
Tim

Hi

Got it to work now!

Thanks
Tim

Hi! I'm having the same problem, but since the resolution for this was not posted, I'm not sure how to enter. I have a list of subtotals (7 possible subtotals) and then need the grand total, but would like without the $0.00 showing. I'm using Acrobat 9 pro (Acrobat Forms). Thanks!

Carefully read my post, I have included the code for both Acrobat and LiveCycle Designer forms.

Your situation is different because you are not displaying a pure numeric value but a formatted string value. If you remove the currency format, then the code will work.

If you need to use the currency symbols you will need to the necessary code to change the displayed format to exclude the currency symbol. Searcg for "AFNubmer_Format"

Setting number format to a text field..
A sample script:

if(event.value == 0 | event.valueAsString == "") {
event.value = "";
AFNumber_Format(2, 0, 0, 0, "", false);
} else {
AFNumber_Format(2, 0, 0, 0, "$", true);
}

Hi George,

Thanks so much for your reply. I wasn't quite sure how to execute your code, but your tip on removing the currency format helped a lot.

I found another post on an Adobe forum with instructions to use simple calculations in conjunction with a custom validation code.

This string in the subtotal columns: if(event.value == 0 | event.value == '') event.value = '';
This string in the grand total field: if (event.value == 0) event.value = "";


As you stated, it didn't work with the dollar sign in the grand total field, but once removed everything is working fine now.

Thanks! I really appreciate your time.

Hi Again George!

It took me longer for your explanation to sink in since I'm not a programmer, but realized exactly what you were describing so ended up using your script and everything is working great!

Thanks again for your help!

Hi George,
I'm new to this and I'm using LCD 8.1. I would like to know how you set the Presence field using the code you gave. In the object palette, the presence can only be selected not manipulated.

Thanks
Paul

你好

网站托管的
“

你好

<网址=“htt​​p://www.crocodilenetworks.com
“>的VPS