I need assistance in calculating BMI. I have different custom fields such as height in meters, height in feet, height in inches, weight in pounds, weight in kg and weight in stones.
So whatever information we get from the client we want to calculate BMI as per values inserted in any of the fields. Basically formula should convert feet pound/stones value into kg and calculate the BMI.
Please help. Any assistance would be greatly appreciated.
14 respuestas
Try :
IF(
NOT(ISBLANK(Weightkg__c)) ,
Weightkg__c / Height_feet_Inches_to_meters__c ,
IF(
NOT(ISBLANK(Weight_Pound_to_Kg__c)) ,
Weight_Pound_to_Kg__c / Height_feet_Inches_to_meters__c,
IF(
NOT(ISBLANK(Weight_stones_to_kg__c)),
Weight_stones_to_kg__c / Height_feet_Inches_to_meters__c,
null
)
)
)
There might be an issue with you trying to check for null.
