I am new to the whole form design functionality in Adobe. I have a form that I have created that has multiple fields calculating off each other. I have managed to get all the fields to calculate correctly, but I'm having trouble figuring out the correct formula for one field.
After/during field 3 calculation, I need the value to return 1000.00 if greater than 1000.00 else return Field 3 amount.
| Formula | Current Calculations | Correct Calculation Example 1 | Correct Calculation Example 2 |
|---|
| Field 1 - Annual Salary (User enters) | 100000.00 | 100000.00 | 30000.00 |
| Field 2 - Weekly Salary (calculation is: field 1 / 52) | 1923.07 | 1923.07 | 576.92 |
| Field 3 - Benefit Maximum (calculation is: field 2 * .60) | 1153.84 | 1000.00 | 346.15 |
| Field 4 - Hidden Field (calculation is: field 3 - 100.00) | 1053.84 | 900.00 | 246.15 |
| Field 5 - Monthly Cost (calculation is: field 4 * .025) | 26.34 | 22.50 | 6.15 |
| Field 6 - Pay Period Cost (calculation is: field 5 * 12 / 26) | 12.15 | 10.38 | 2.83 |
After/during field 3 calculation, I need the value to return 1000.00 if greater than 1000.00 else return Field 3 amount.
Any suggestions on how to get this to work? Tried setting this up using Java Scipt, but when I do, the fields dissapear alltogether.
