add column of numbers then calculate average

[AMC-AMC]

I have created a utility form for my clients to fill out & e-mail the data back to me which I then import back into the form.  Is there a way in Acrobat 8 Pro or Livecycle 8 to add a column of numbers then divide by 12 to determine the yearly average & enter it into my form?  Thanks for any help!!  If you need to see my file just let me know or maybe I'll have to start from scratch!

[Former Community Member]

You simply add the fields together using fieldName.rawValue then divide by 12. Something like this (javascript):

yearlyAverageField.rawValue = (Field1.rawValue + field2.rawValue + ......)/12;

Paul