+ Start a Discussion
Matt Weisberg 3Matt Weisberg 3 

Why doesn't my health score work? I am using multiple IF functions to ensure the denominator is not too large when numerators are zero

NPS_Input__c + CSAT_Input__c + Licensed_User_Activity__c / (IF(NPS_Input__c=0, 2,IF(CSAT_Input__c=0,2,IF(Licensed_User_Activity__c=0,2,IF(NPS_Input__c=0 && CSAT_Input__c=0,1, IF(NPS_Input__c=0 && Licensed_User_Activity__c=0,1,IF(CSAT_Input__c=0 && Licensed_User_Activity__c=0,1,3 )))))))

All inputs are % responses.
ShivankurShivankur (Salesforce Developers) 
Hi Matt,

What does this formula outputs, is it throwing any error or showing as blank? Can you post a screenshot of error, if any?

Also, give it try with below formula format:
NPS_Input__c + CSAT_Input__c + Licensed_User_Activity__c /
(IF(NPS_Input__c=0,2,
IF(CSAT_Input__c=0,2,
IF(Licensed_User_Activity__c=0,2,
IF(AND(NPS_Input__c=0,CSAT_Input__c=0),1, 
IF(AND(NPS_Input__c=0,Licensed_User_Activity__c=0),1,
IF(AND(CSAT_Input__c=0,Licensed_User_Activity__c=0),1,3)
)
)
)
)
)
)

Reference: https://help.salesforce.com/articleView?id=sf.customize_functions_i_z.htm&type=5

Hope above information helps, Please mark as Best Answer so that it can help others in the future.

Thanks.