+ Start a Discussion
rayraysrayrays 

Getting #Error! when on field when diving 2 fields with 0

Competitor Final Rate / KP Final Rate is giving #Error! on Rate Position.  How would I create a condition that if the number is 0, leave as blank?  Thanks.

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis
IF(
OR(FinalRate = 0,KPFinalRate = 0),NULL, 
FinalRate / KPFinalRate ) 

 

All Answers

Steve MolisSteve Molis
IF(
OR(FinalRate = 0,KPFinalRate = 0),NULL, 
FinalRate / KPFinalRate ) 

 

This was selected as the best answer
rayraysrayrays

Thanks, Stevemo!