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

Weighted averages in a form

grissettpp
Registered: Mar 19 2009
Posts: 2

I'm creating a Performance Evaluation Form which uses weighted averages. Each objective has a percentage and a score. Can you help me with how to put a weighted average formula in the form?
Pauline

My Product Information:
LiveCycle Designer, Windows
radzmar
Expert
Registered: Nov 3 2008
Posts: 1202
FormCalc offers a function to calculate averages.

FormCalc script for calculate event of AverageField.

Avg(NumField1, NumField2, NumFiel3)

For example:

NumField1 = 2
NumField2 = 4
NumField3 = 3

AverageField = 3

radzmar
LoveCycle Blog
Documents you need:
LiveCycle Designer ES2 Docs

gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Are you computing the [url=http://en.wikipedia.org/wiki/Weighted_mean]Weighted Mean[/url] or do you want to apply a special weighting by objective?

For the Weighted Mean, you will need the mean for each objective the number of item in each objective and apply the formula.

For a custom weighting you use you weighting factor for each objective instead of the N of each objective to compute the weighted average.

George Kaiser