I have 3 fields on the Opportunity that help set Sales Commission
- Sales_Commission_Suggested
- IF(RecordType.DeveloperName = "Material_Bank" && Annual_Revenue_from_Account__c >= 5000000 && Renewal__c = FALSE && IsClosed = FALSE, 750.00, NULL)
- Sales_Commission_Override
- Currency Field
- Manager can put any amount here
- Sales_Commission__c
I need help with a FORMULA for (Sales_Commission__c)
- If Sales_Commission_Suggested__c (IS BLANK) and Sales_Commission_Override__c (HAS A VALUE)
- Sales_Commission__c should be same as Sales_Commission_Override
- #Sales Cloud
1 个回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Christopher,
I assume if Sales_Commission_Suggested__c is not blank, you want to display it?
If so:
BLANKVALUE(Sales_Commission_Suggested__c , Sales_Commission_Override__c )
Make sure you select "Treat blank fields as blank"
