Alternative Field Calculations

[Bradley24287170n5ls]

Hello, I'm new here and I'm trying to learn how to do something that may or may not be possible in Adobe.  I'm in the mortgage industry and I'm creating a form with the following fields: "Purchase Price", "Down Payment Amount", "Down Payment Percent", "Loan Amount", and "Loan-to-Value Ratio". Mathematically speaking, data only ever needs to be manually entered into any two of the five fields and the remaining three fields can be calculated based on the entered data, regardless of which two fields the user chooses to manually input. I currently have the field calculations set for the user to enter the Purchase Price and the Down Payment Amount, and the remaining three fields (Down Payment Percent, Loan Amount, and Loan-to-Value Ratio) are automatically calculated. Is it possible to make it so that regardless of what two fields the user chooses to manually enter the data, the other three can be calculated? I've included a snip of the fields just to provide a visual. Any help is appreciated - willing to pay to have someone write the script for me. Thank you!

[Nesa Nurani]

It's possible, but you need atleast one money value field filled, you can't do it if user fill only percentage fields.

[Bradley24287170n5ls]

Yes, you're right and I realized that after I posted. Entering the down payment percentage and the loan to value ratio would not calculate the other three fields. Are you able to help with the script?

[bebarth]

Hi,

See the attached file.

You can set the decimal places for prices.

@+