Skip to main content
Michael Dely 님이 #Collaboration에 질문했습니다
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개
  1. 2018년 5월 1일 오전 1: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 )