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

Problem With Form Fields - calculation

Forum Index > JavaScript > Problem With Form Fields - calculation
2007-12-25 05:30:00
jim_dickey
Registered: Dec 25 2007
Posts: 11

I a form and am having a number of problems:
 
1. When I hit the reset button I get the error messages:
 
a. "The value entered does not match the format of the field [ROI]"; and
b. "The value entered does not match the format of the field [MoEqCost]"; and
 
2. When I reset the form and enter a number in the “profit from Services" box I get the error "The value entered does not match the format of the field [Rate]" - and the form goes back to the “rate” field and changes it to another number (re-divides it by 100).
 
3. Other than that, the form seems to calculate properly (i.e., the formulas seem right).
 
Any help is appreciated.

My Product Information:
Acrobat Pro 6.0.0, Windows
Top
2008-01-02 17:41:51
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Well, either there is an error in the form, or the data entered incorrectly.

Is this a form you are developing? Is the problem with the calculated fields, or user entered fields? Is this an AcroForm or a LiveCycle Form?

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

Top
2008-01-03 01:31:56
#2
jim_dickey
Registered: Dec 25 2007
Posts: 11
I think the issue is with a NaN calculation in Acrobat. I can do the calculation in excel, no problem - I just wanted Acrobat because it's more elegant. However, expressed in Excel, the two calculations are as follows:

1. I need a script to divide two numbers (in excel the division is expressed as follows):

=-M66/F66

Where M66 and F66 are real numbers.

2. I need a script to perform a PMT calculation variable based upon the number of years(in excel the nested string is expressed as follows):

=IF(J48=1,PMT(J54/1200,J55,J53),IF(J48=2,PMT(J54/1200,J55,J53),IF(J48=3,PMT(J54/1200,J55,J53),IF(J48=4,0,IF(J48=5,0)))))

Where J48 is a year, J54 is an interest rate, J55 is the loan term, and J53 is total cost.
Top