Multiple Formulas in Calculated Field
-
I am creating a BMI calculator with two settings (metric and imperial)
So in the end i have 2 formulas for calculating the final number.My Calculator flow is as follows
– Radio Button (Metric / Imperial)
– when a person select metric or imperial it shows their respective number fields
(weight and height)
– A calculated field with BMI formula which shows final resultI want the calculated field to use metric formula when the metric radio button is selected and Imperial formula if the imperial button is selected.
can you please help.
Here is my final formula for calculated field (for imperial calculation )
prec((fieldname3/(((fieldname6*12)+fieldname8)*((fieldname6*12)+fieldname8))*703-1),2)
where:
fieldnumber3 = weight in pounds
fieldnumber6 = height in feet
fieldnumber8 = height in inchesand here is my formula for metric system
prec((fieldname11/((fieldname10*0.01)*(fieldname10*0.01))-1),2)
where:
fieldnumber11 = weight in kg
fieldnumber6 = height in centimeter
The topic ‘Multiple Formulas in Calculated Field’ is closed to new replies.