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 respuesta
Hi Violeta, Try this:
Manager_Forecast_Amount__c*
CASE(Manager_Forecast_Category__c,
"Commit", 1,
"Probable", 1,
"Reviewed", 1,
"Best Case", 0.5,
0)
