My current formula is becoming 16,008 when compiled. Before I proceed to creating a workflow rule, I thought to post here and confirm if I have missed naything in my current formula. Probability is a picklist field. I tried the formula with Nested IF() but still threw the same error.
CASE(Probability__c,
'10%', Funding_Amount__c*0.10,
'20%', Funding_Amount__c*0.20,
'30%', Funding_Amount__c*0.30,
'40%', Funding_Amount__c*0.40,
'50%', Funding_Amount__c*0.50,
'60%', Funding_Amount__c*0.60,
'70%', Funding_Amount__c*0.70,
'80%', Funding_Amount__c*0.80,
'90%', Funding_Amount__c*0.90,
'100%',Funding_Amount__c*1.00,0)
Appreciate any help on this.
5 réponses
Hi Vinitha, Try this:
Funding_Amount__c * VALUE(SUBSTITUTE(TEXT(Probability__c), "%", null))/100
