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)
