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
sudhirn@merunetworks.comsudhirn@merunetworks.com 

Replace null with 0

Hi, 

 In opportunity amount I need to create a formual condition should be 

  If amount = null replace that with 0 else amount value 
  
  Please suggest me how to add this condition. 

Thanks
Sudhir
Kay AndersonKay Anderson
Do you want to add a formula or do you want to put a zero in the input field?

Formula:  IF (ISBLANK( Input_Field__c),0,Input_Field__c)

Or you could write a process in Process Builder that runs on the object and filters on Input_Field__c is blank does a record update and inserts 0.

Hope that helps.
Deepak GulianDeepak Gulian
IF(ISNULL(Amount) , 0, Amount )
Pankaj_GanwaniPankaj_Ganwani
Hi,

Please refer the attached screenshot for the same:

User-added image
sudhirn@merunetworks.comsudhirn@merunetworks.com
Thank you all for your responce 

I am bit confused to use IF (ISBLANK( Input_Field__c),0,Input_Field__c) or IF(ISNULL(Amount) , 0, Amount ) 

Again as Pankaj mentioned there is a default option to set Zero when blank 
Kay AndersonKay Anderson
Any of the above.  Pankaj's response is the easiest.
Deepak GulianDeepak Gulian
But according to the question, formula condition need to be implemented on the Oppotunity Amount field. So workflow is going to work in this situation and workflow dont have these checkbox options in it.
IF(ISNULL(Amount) , 0, Amount ) so this will work.