Formatting a calulated field in javascript

Question

I have a calculation that needs to return a currency value ($ symbol & two decimal places) if a field (A) used in the calculation is filled in (ie: showing a number value) then the Result field must show $x,xxx.xx.

(Currency + comma separator + two decimal places)

My calculation is set to be blank when field (A) is blank. I can't set the format for my result field to currency as it returns an error when Field (A) is changed from a value to blank.

What is the javascript to set this up and is it entered into the custom format script block?

Thanks

Thom Parker · Accepted Answer

Hi ThomThanks, but that doesn't work either - still shows the $0.00Opps should have not forced it to a string event.value = ((event.value==0) || isNaN(event.value))?"": util.printf("$%,0.2f",event.value); Just to be sure though. Before making this update. Remove all formatting from the field. What appears in the result field when A is blank?  The script will only show a blank if the actual calculated field value is either a 0 or something that is not a number.

Thom Parker · Answer

Put this code in the custom format script.

event.value = ((event.valueAsString=="") || isNaN(event.value))?"": util.printf("$%,0.2f",event.value);

Here's an old article on formatting

https://acrobatusers.com/tutorials/formatting_text_fields/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded