Skip to main content
Topics#Data ManagementFrage von Scott Winstanley
Scott Winstanley (Hello Soda) fragte in #Data Management
9. Dez. 2016, 11:38

Hi, I want to pull Opportunity "Amount" into a new field, but only if the Opportunity has a "Probability" of 100....

 ...the IF formula below seems right on paper but is always returning 0 regardless of "Probability":

 

 

IF( (Probability = 100), Amount , 0)

 

Any help would be greatly appreciated,

 

Thanks
2 Antworten
  1. Sunil Sarilla (M&G Investments)
    9. Dez. 2016, 11:49

    Please try the below

    IF(Probability = 1, Amount , NULL)

    As per the field will show with the Amount if the Probability is 100% or the field will be blank

     

    if you want to show 0 instaed of field being blank then the formula will be

     

     

    IF(Probability = 1, Amount , 0)

     

     
Antwort schreiben...
0/9000