Skip navigation
Currently Being Moderated

Help needed with FormCalc scripting in LiveCylce 8.0

Apr 16, 2009 10:05 AM

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.00100000.0030000.00
Field 2 - Weekly Salary (calculation is: field 1 / 52)1923.071923.07576.92
Field 3 - Benefit Maximum (calculation is: field 2 * .60)1153.841000.00346.15
Field 4 - Hidden Field (calculation is: field 3 - 100.00)1053.84900.00246.15
Field 5 - Monthly Cost (calculation is: field 4 * .025)26.3422.506.15
Field 6 - Pay Period Cost (calculation is: field 5 * 12 / 26)12.1510.382.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.

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points