These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Average field not calculating average - Simple form..?

Forum Index > Forms: Acrobat > Average field not calculating average - Simple form..?
2011-02-28 06:35:45
cmk
Registered: May 20 2008
Posts: 3
Answered

Hi All - I hope someone can assist - I'm new to AcroForms...I have what I think is a very simple Employee Appraisal form. Basically 20 questions with a score field and a comment field for each question. The total field is supposed to average all of the score fields. I have even added a field that could be used as a manual calculation due to some instances that the question doesn't apply (and since I don't know how to do JavaScript)the manager could just manually calculate the fields - but if all the questions are filled out then I would like the average (ex 5.3) to show. What am I doing wrong? I am using Acrobat 9 Pro
 
Thank you
CK

Christina

My Product Information:
Acrobat Pro 9.4.2, Windows
Top
2011-02-28 07:14:01
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
Both Acrobat forms tool and LiveCycle Designer have a simple Average, Mean, capability. Acrobat and LiveCycle Designer do not calculate the average mean in the same manner. Acrobat includes null values as a zero score and LiveCycle Designer omits the null values from the calculation.

If you want to omit fields marked as not applicable, then you need to write some custom script to not sum and not count those items.

For Acrobat forms see How to do (not so simple) form calculations by Thom Parke.For LiveCycle Designer under the menu option for "Help" click on the 'Scripting Reference' and look for the "Avg" function.

Mover information will be needed to provide a more detailed answer.

What program are you using to design the form?
How are the not applicable fields identified?
How type of field are the scores being entered into?
What are the field names?

George Kaiser

Top
2011-02-28 07:27:57
#2
cmk
Registered: May 20 2008
Posts: 3
thank you for your response - I did however use the simple average (i'm not worried about the 0 values at this point - i just want it to work will all of the numbers entered). My issue is that the calculation is not showing up any longer i enter values in all fields and the average still shows 0.

Christina

Top
2011-02-28 08:19:52
#3
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
Accepted Answer
Have you or has an update to Acrobat turned of JavaScirpt?

Are there any massages in the JavaScirpt Debugging Console?

George Kaiser

Top
2011-02-28 08:57:18
#4
cmk
Registered: May 20 2008
Posts: 3
The javascript had been turned off - THANK YOU!

Christina

Top