Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

JeffBinTN
JeffBinTN
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
4

Discussions

Discussions
0

Questions

Questions
0

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by JeffBinTN
Customize the badges you want to showcase on your profile
Re: Change User Entered Decimal Value prior to Calculate Event? - Adobe LiveCycle 14-07-2010
Another solution was to put "if([DENOMINATOR]>0)then[FORMULA]endif", in place of your formula alone.

Views

671

Likes

0

Replies

0
Re: User entered Variables - Adobe LiveCycle 14-07-2010
I had something similar and it was because the denominator was a zero before the user entered the variables. It was fixed with an "if/then/endif".It looks like the problem in yours is form1 being zero. Tryif([YOUR DENOMINATOR]>0)then[YOUR FORMULA HERE]endifExample:if(form1>0)then(this.rawValue=form1.#subform[0].NumericField4.rawValue / form1.#subform[0].NumericField5.rawValue)endifYour formula is a bit more complicated than I can decipher, so I'm not sure how much after the "/" you need to inclu...

Views

302

Likes

0

Replies

0
Re: Arithmetic over/underflow - Adobe LiveCycle 14-07-2010
Found the answer myself. It was a problem with a zero denominator. By using an if/then/endif you can control when it's trying to run the calculation.The original formula was (weight*703)/(height*height).The solution was:if(height>0)then(weight*703)*(height*height)endifThat prevents it from trying to run the calculation before a value has been entered in 'height'.

Views

224

Likes

0

Replies

0
Arithmetic over/underflow - Adobe LiveCycle 14-07-2010
On a form used in our hospitals for pre-admitting patients I'm trying to calculate BMI from height and weight. I've put the formula in the script editor and it correctly calculates BMI, but when the form is first opened the following error message appears:Script failed (language is formcalc; context is xfa[0].form[0].F[0].#subform[1].BMI[0]) script=(Weight*703)/Height*Height)Error: arithmetic over/underflow.I suspect this is because the denominator (Height*Height) is zero before a value has been...

Views

2.4K

Likes

0

Replies

1