Criteria
If Manager Forecast Category (picklist field) equals Commit or Probable or Reviewed then add the amount in the field Manager Forecast Amount if Manager Forecast Category (picklist field) equals Best Case then add 1/2 of the amount from the field Manager Forecast Amount. thanks
1 risposta
Hi Violeta, Try this:
Manager_Forecast_Amount__c*
CASE(Manager_Forecast_Category__c,
"Commit", 1,
"Probable", 1,
"Reviewed", 1,
"Best Case", 0.5,
0)
