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