I have 3 fields defined. First is Weight, Second is Height, Third is defined to do a calculation (specifically Weight divided by height) to get Body Mass Index.

What functions would I use to grab the contents of Weight and Height and have them divided to get the BMI result?

What would be the best way to enter a height of 5'6" in the system so that the calculation would flow properly? (5.6 perhaps?)

Thanks for your help in advance.

Chris

Have three fields: heightf (feet), heighti (inches), and weight (lbs). Then the calculated number field BMI would be

Let ( [ h = heightf*12 + heighti] ;

703 * weight/(h^2)

)

Wouldn't it be more accurate to have the ounces included in this also?

I would have the Height expressed in inches and the weight expressed in ounces, and then do the calculation.

You could also express the feet and pounds with percents of them. BTW, 5' 6" isn't 5.6', it is 5.5'

Food for thought.

HTH

Lee

Typically, weight is measured by pounds (U.S. Standard) or Kilograms (Canada, and European Standard) for general physician use.

Ounces are only used for Babies in a hospitals L&D environment If you had a baby that is a patient, then you could use ounces but at the typical physician/ doctors office, the scale they weigh you on is the old fulcrum type scale.

There would have to be some re-engineering to document babies vitals.

Good consideration though nonetheless

Why do not use WeightKg and heightcm and translate the foot an inches and pounds and ounces however formatted to the european way?; the result is BMI anyway and you can decide whether to show or not the option of both measures depending if you use define fields or not to get the values. Also you could do a field menuchoice or sth similar where you ask which measurement the end user wants to use?

That is a good consideration as well Pelisio. Use a button to calculate the result specific to what you are expecting. This is going to be the best method to satisfy all needs. The formulas will have to change. I will post back what the two formula types are shortly and evaluate the calculations require with you guys.

Ok Guys...heres a new problem with this calculation setup.

Using the previous defined fields; "Height" "PreOPWeight" and "BMI". We have the following: (Note that the height is all measured in Inches. Decided to do away with the Feet/Inches senario)

I have this calculation setup in the "BMI" Field to auto enter:

Let ( [ h = Height];

703 * PreOpWeight/(h^2)

)

Whenever I start to type in the height, in the BMI Field, I get a "0" and when I enter the Weight, I get no result right away in the BMI Field. What could be causing this problem? Thanks for your help!

Chris

There's no advantage in using Let here since you're only referring to the field once. 703 * PreOpWeight / (Height ^ 2 ) will work just as well. I would guess that you have 'Do not replace existing value for field' selected in your auto-enter option, which needs to be deselected for the field to update. Of course you will have to tab to another field or exit the record for the field to update.

Personally I have gone from 43 to 22 in one year.

Here is my contribution

I have attached a sample file.

http://homepage.mac.com/oceanwest/PhotoAlbum19.html

http://www.sandiegobariatric.com/site/results.php

BMI.fp7.zip

Congrats Stephen! That is one heck of an accomplishment!

On the subject of the calculation, I have changed one feature. I have added an "=" button that the user clicks and it will give them the result. Now, I just need one last thing resolved.

The BMI number result is coming back in the format "28.2432432432432432" How do I setup the calculation to where I just get "28.4". The tenth of the decimal?

Round((Weight*703) / (Height ^ 2);1)