Kevin asked about calculating and classifying a BMI using FileMaker Pro. The two formulas will be included in the tutorials for the eBook I am writing. In this blog, I will describe how to calculate the BMI. In the Metabolic Syndrome Database the patient's height in feet and inches are separate fields in the Patient table. Generally, the height of an adult does not change. However, Kevin, as a pediatric nursing practitioner student, should include height in the visit table. A child's height will change with age.
Use the CDC BMI calculation appropriate for the client. According to the CDC, the adult BMI formula is (Source: http://www.cdc.gov/healthyweight/assessing/bmi/adult_bmi/index.html )
I prefer to create and edit FileMaker Pro tables from the File > Manage > Database view. The first step is to instruct FileMaker that the field is a calculated value. That instruction opens a window to enter the formula. A really easy way to create the formula is to choose the fields from the pertinent tables from the tables drop-down menu. You do not need to insert an equals sign (=) before a formula because FileMaker does that for you.
Next, I had to create a calculated field to determine height in inches. The formula noted below in the Visit table is
(Patient::HtFt*12)+Patient::HtIn
The two :: tells FileMaker to obtain the value from the Patient table. HtFt and HtIn are two fields in the Patient table. The caret (^) is used to instruct FileMaker to square the height in inches.
The formula for BMI is (Weight * 703)/(Height In^2)
Use the CDC BMI calculation appropriate for the client. According to the CDC, the adult BMI formula is (Source: http://www.cdc.gov/healthyweight/assessing/bmi/adult_bmi/index.html )
| Measurement Units |
Formula and Calculation
|
|---|---|
| Kilograms and meters (or centimeters) | Formula: weight (kg) / [height (m)]2
With the metric system, the formula for BMI is weight in kilograms divided by height in meters squared. Since height is commonly measured in centimeters, divide height in centimeters by 100 to obtain height in meters.
Example: Weight = 68 kg, Height = 165 cm (1.65 m)
Calculation: 68 ÷ (1.65)2 = 24.98 |
| Pounds and inches | Formula: weight (lb) / [height (in)]2 x 703
Calculate BMI by dividing weight in pounds (lbs) by height in inches (in) squared and multiplying by a conversion factor of 703.
Example: Weight = 150 lbs, Height = 5'5" (65")
Calculation: [150 ÷ (65)2] x 703 = 24.96 |
I prefer to create and edit FileMaker Pro tables from the File > Manage > Database view. The first step is to instruct FileMaker that the field is a calculated value. That instruction opens a window to enter the formula. A really easy way to create the formula is to choose the fields from the pertinent tables from the tables drop-down menu. You do not need to insert an equals sign (=) before a formula because FileMaker does that for you.
Next, I had to create a calculated field to determine height in inches. The formula noted below in the Visit table is
(Patient::HtFt*12)+Patient::HtIn
The two :: tells FileMaker to obtain the value from the Patient table. HtFt and HtIn are two fields in the Patient table. The caret (^) is used to instruct FileMaker to square the height in inches.
The formula for BMI is (Weight * 703)/(Height In^2)
That is all there is to creating the BMI formula. Kevin would need to use the BMI formula for children. It can be adapted from http://apps.nccd.cdc.gov/dnpabmi/
