Skip to main content
I have a picklist that has different percentage selections (Not Started, 25%, 50%, 75%, Complete).  I want to multiply the % from that field by a currency field (Total Opportunity) to give us a Weighted Opportunity.  So if 50% is selected and the currency field is $3MM, the Weighted Opportunity would be $1.5MM.  There are 4 fields in total and the Picklist, Total Opportunity, and Weighted Opportunity are pulling fine, but I am looking to convert the picklist into a number field.  This will enable the Weighted Opportunity to automatically pull the calculation.  Please let me know if there is an easy way for me to accomplish this. 

 

Thanks.  
2 Antworten
  1. 1. Mai 2018, 01:39
    What % values do you want to convert the "Not Started" and "Complete" vales to?  

     

    Are you trying to do something like this? 

     

     

    Total_Opportunity__c *

    CASE( PickList_Field ,

    'Not Started', 0,

    '25%', 0.25 ,

    '50%' , 0.50 ,

    '75%' , 0.75 ,

    'Complete' , 1.00 ,

    0 )