Expand my Community achievements bar.

JeffBinTN
JeffBinTN
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Another solution was to put "if([DENOMINATOR]>0)then[FORMULA]endif", in place of your formula alone.

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • 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=for...

    Type

    Discussions

    Views

    938

    Likes

    0

    Replies

    0
  • 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 ...

    Type

    Questions

    Views

    439

    Likes

    0

    Replies

    0
  • 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; contex...

    Type

    Questions

    Views

    2.6K

    Likes

    0

    Replies

    1
Top badges earned by JeffBinTN
Customize the badges you want to showcase on your profile