Calculate average for fields, ignore blank field, and not show 0

[Karl Sheeran]

I have looked through several posts already and have not found a solution that works for me unfortunately. I have a form that has a dropdown form field with the options: " ","1","2", "3", "4", "5". The first blank is so there is not a value displayed if the field has not been answered yet. I would like to calulate the average for the fields and not show the 0 if the average has not been calculated yet. The fields are titled "A1","A2"..."A8". I would appreciate any help. Thank you very much.

[JR Boulay]

In the text field use the "average" calculation, and place this JavaScript as a Custom Format Script to hide the zero:

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

[Karl Sheeran]

Unfortunately I cannot use a custom format script. I tried using that already but when I open the file in Chrome, the 0 shows. I apologize, I should have specified that I was trying to open it in an internet browser.

[Bernd Alheit · Accepted solution]

Read this :

https://community.adobe.com/t5/acrobat-sdk/average-ignoring-empty-fields-zero-values/td-p/8983136 

[Karl Sheeran]

I got it to work. Thank you very much!