format of a field with a formula

[robertb87361850]

Hi,

I 

I am attaching a form with a simple formula in field 20, where we add up fields 10-19.
How do I change the format of field 20 so that '0' does not appear if none of the fields from 10 to 19 are filled ?

Thank you very much for your help !

WS.

[Nesa Nurani · Accepted solution]

Use this as custom format script:
if(event.value){
event.value = util.printf("%,2.2f",event.value).toString().replace(/\./gim," ");}

Then use this as 'Validate' script:
if(event.value == 0)
event.value = "";

[robertb87361850]

Thank YOU ! ❤:rose::rose::rose::rose::rose:

[robertb87361850]

Nesa, could you please look at below post ?
https://community.adobe.com/t5/acrobat-discussions/problem-with-number-format/m-p/14704029#M468736