function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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 :-/Steve :-/
IF(
OR(FinalRate = 0,KPFinalRate = 0),NULL, 
FinalRate / KPFinalRate ) 

 

All Answers

Steve :-/Steve :-/
IF(
OR(FinalRate = 0,KPFinalRate = 0),NULL, 
FinalRate / KPFinalRate ) 

 

This was selected as the best answer
rayraysrayrays

Thanks, Stevemo!