BMI Calculator using formula field #inSalesforce

on

BMI Calculator using formula field #inSalesforce


Suppose you have custom fields

height in meters
height in feet
height in inches
weight in kg
weight in stones


Formula like:

IF(
NOT(ISBLANK(WeightInKG_c))  , 
WeightInKG_c/HeightFeetInchesToMeters__c ,
IF(
 NOT(ISBLANK(WeighPoundToKG__c)) , 
 WeighPoundToKG__c/HeightFeetInchesToMeters__c, 
 IF(
 NOT(ISBLANK(WeightStonesToKG__c)), 
 WeightStonesToKG__c/HeightFeetInchesToMeters__c,
 null
 )
 )
)

Comments

Post a Comment