function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
B2AB2A 

Formula field - treat "0" as a blank when I want to differentiate between the two

Hello All,

 

I've created the following formula, however I noticed if the field is 'blank' it is treated as ' = 0 ', which it should not.

 

I've tried using ISBLANK, and BLANKVALUE, with no luck.  Any ideas guys?

 

IF( LS_Implicit_Lead_Score__c > 39, 
IMAGE("URL", "Hot, Hot, Hot"), 
IF( LS_Implicit_Lead_Score__c > 29, 
IMAGE("URL", "Looks Promising"), 
IF( LS_Implicit_Lead_Score__c > 0, 
IMAGE("URL", "Getting Warmer"), 
IF( LS_Implicit_Lead_Score__c = 0, 
IMAGE("URL", "Check for a Pulse"), 
IMAGE("URL", "Good Luck")))))


 
Thanks.
 


B2AB2A
I Resolved this myself.  Problem was that is was treat blank fields as zero, rather than as blank.