I have a requirement in which I need to create a
Formula(Currency) field that will multiply a field of type
Formula(Currency) with a
picklist containing`percent value.
I am stating fields name & values it contains also I am stating the Formula that I created which is throwing error.
- Total Revenue - This field is a Formula(Currency)
- Win Probability - Picklist with Values
20%, 50%, 80%, 100%
Formula that I tried building was:
Total_Revenue__c * VALUE( TEXT(Win_Probability__c ))