How to calculate the average of fields with values.

Forum|Forum|6 years ago
May 29, 2019
1 reply
2185 views

How would I write the formula in adobe?

Message was edited by: Malcolm Thomson

Acrobat SDK and JavaScript

This topic has been closed for replies.

try67

Community Expert

So basically you want to ignore empty fields, right? I posted code that does that on these forums. Search for "calcAverage" and you should be able to find it.

traceyh53384130Author

Participant

I'm brand new to Adobe, so unsure of where to put the script and make it work. I went into custom script and edit and pasted the script you had written. also brand new at calculations, so sorry if I sound stupid.

when you say fields in your script, does that mean I put my fields everywhere it says fields? below are the fields I am looking at

try67

Community Expert

Yes, this code should be used as the custom calculation script of the field where you want to show the result.

You need to enter the names of the fields, between quotes, into the fields array, yes.
Give it a try and post here how it goes... If it's not working correctly press Ctrl+J and check if there are any error messages in the window that opens.

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