Skip to main content

Hello Everyone,

I need to have a formula field with different action level.

I have a formula field 'Booking Financier'

And in this field I would like to verify if another field is >0 and IF 0 I verify another field

 

For Example :

Booking Financier Field =

 1 : IF(Booking_Financier_manual_entry__c >0 (put this value )

2 : IF(Total_perpetual__c =0, Total_Recurring_Booking__c ,(Total_perpetual__c + Total_Recurring_Booking__c ) >0 (put this value) 

AND IF 1 and 2 =0  IF(Booking_Sales_Estimated__c,  (put this value)

 

I don't know if it is possible ...

Thank you

2 件の回答
  1. Michael Brown (Salesforce) Forum Ambassador
    2022年4月15日 13:11

    Hi Delphine, 

     

    Are you looking for something like this?

     

    This will go through each field in order of priority and return the first one that isn't equal to 0:

    1. display booking Financier manual entry if that is greater than 0

    2. If Booking Financier manual entry = 0, it will display total perpetual if that field is greater than 0

    3. If Total Perpetual is also = 0, it will display total recurring booking if that field is greater than 0

    4. If Total Recurring Booking is also = 0, it will display Booking Sales Estimated if that field is greater than 0

    5. Finally, if all of these fields are equal to 0, the formula will return 0

     

    IF(Booking_Financier_manual_entry__c > 0,Booking_Financier_manual_entry__c,

    IF(Total_perpetual__c > 0,Total_perpetual__c,

    IF(Total_Recurring_Booking__c > 0,Total_Recurring_Booking__c,

    IF(Booking_Sales_Estimated__c > 0,Booking_Sales_Estimated__c,0))))