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

Monthly PMT calc - errors????!!!

gmvirtual
Registered: Oct 3 2007
Posts: 5

Please assist, i am doing a Monthly payment calculation field and when I put the field labels in the calculation the form returns errors. If I "hard code" the numbers it works perfectly. I have been pulling my hair out for hours and I give up....can you please assist.
 
This works:
Pmt(814000, 0.065 / 12, 25 * 12)
 
But this does not:
Pmt(LoanAmtRequested, Rate / 12, 25 * 12)

My Product Information:
LiveCycle Designer, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
What errors are returned?

I'm assuming that you are using FormCalc in a LiveCycle form? If this is correct, then it's possible that the SOM path to the input fields is incorrect. To test this and get the correct SOM Path, try a simpler calculation, like this:

LoanAmtRequested + Rate

If you continue to get errors then there is something else wrong. With out specific information we can't give you any advice, so please be specific.

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

gmvirtual
Registered: Oct 3 2007
Posts: 5
Can you take a look at it?? I uploaded it to here:
[url=http://www.gmvirtual.com/NewCRESheetaa.pdf]http://www.gmvirtual.com/NewCRESheetaa.pdf[/url]

I've tried the more simple...but still getting the errors.

Thank you so much, this has been making me nuts.
gmvirtual
Registered: Oct 3 2007
Posts: 5
Sorry, the link is wrong above, the correct link for the pdf file is:
[url=http://www.gmvirtual.com/NewCREDCR.pdf]http://www.gmvirtual.com/NewCREDCR.pdf[/url]

thanks!