Skip to main content
Topics#Data ManagementTOL O's Question
TOL O asked in #Data Management
Aug 21, 2015, 7:45 AM

Formula field help

Hi

 

I have two existing fields

Opportunity Target Premium and Amount

 

I want to create a formula called 'Target Sum' which pulls through the Amount__c premium through but if its 0 or blank then pulls through the opportunity_target_premium__c field.

 

Can anyone help?

 

Thanks

 

Tina

 

 
3 answers
  1. Ajinkya Pande
    Aug 21, 2015, 7:56 AM
    Hi Tina,

     

    You can use formula as below

     

    IF(

     

        OR(  

     

            ISBLANK(Amount__c ),

     

            Amount__c == 0

     

        ), 

     

    opportunity_target_premium__c,

     

    Amount__c

     

    ) 
Write an answer...
0/9000