Averages in Calculations

You will have to write a custom calculation script to count and sum the none-null fields and compute the average.

The exact code will depend upon if you are using LiveCycle Designer or Acrobat to create the forms.

LiveCycle Designer provides a "Sum()" and "Count()" builtin funcitons, see the "Scripting Reference" inlcuded with LiveCycle Designer for more information.

For Acrobat you will could write these funcitons.

I am using Acobat to create the forms. I dont know what the code would be. I have 3 fields named W, X and Y. Then I have a field named Z for the average field. I have tried a couple of codes I found but they did not work.
Bill

Hi billh098,

What code have you tried that didn't work?

Hope this helps,

Dimitri
WindJack Solutions
www.pdfscripting.com
www.windjack.com

I tried to modify this code I found on this forum but could not get it to work. Not sure where to put the first function or how to modify it.
Bill


First, I woul write this function withou field references to make it more universial, and then I would make it a document level funcion so it could be used more than once in a PDF and easily brought into another PDF.

function Avg() {
// computer average of non-empty passed field names
var sum = 0; // sum of fields
var count = 0; // counter for non-blank fields
for(i = 0; i < arguments.length; i++) {
var iField = arguments[i]; // get the i element from passed arguments
var fField = this.getField(arguments[i]).value;
if(!(isNaN(fField)) ) {
// field is a number
if(fField.toString() != '') {
// field is not null or blank
sum += Number(fField); // add to sum
count++; // increment count
} // end not blank
} // end number
} // end loop through arguments
if(count != 0) {
// compute average if there is one or more items to average
return sum / count; // return average
} else {
return '';
} // end no average computed
} // end Avg function


Your custom calculation script then becomes:

event.value = Avg('column.0', 'column.1', 'column.2', 'column.3', 'column.4', 'column.5', 'column.6', 'column.7');

The function is a document level function and requires no changes. It is placed in the document at the doucment level, [url=http://www.acrobatusers.com/tutorials/2007/07/js_document_scripts]Entering Document Scripts[/url].


You only have to change the string of passed field names to the field names ('column.#') that you need to use for the computation.

For the 'Z' field's 'Custom calculation script' would be:

event.value = Avg('W", 'X', 'Y');

Tried this yesterday and could not get it to work, did it today and it worked. Guess I held my mouth different today....
Thanks Again,
Bill