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
Michael Brown (Salesforce) Forum Ambassador
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))))