Skip to main content
Topics#Data ManagementPregunta de TOL O
TOL O ha preguntado en #Data Management
21 ago 2015, 7:45

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 respuestas
  1. Ajinkya Pande
    21 ago 2015, 7:56
    Hi Tina,

     

    You can use formula as below

     

    IF(

     

        OR(  

     

            ISBLANK(Amount__c ),

     

            Amount__c == 0

     

        ), 

     

    opportunity_target_premium__c,

     

    Amount__c

     

    ) 
Escribir una respuesta...
0/9000