 ShowAll Questionssorted byDate Posted Ronty Ahmad

# Can anyone Please help me to simplify this two formula.

/*
End Date of subscrition  and total membership fee Calculation :

Term__c is picklist and values are 12,24,36,48
Start_Date__c  is Start Date of  subscrition .
Rate__c  is number field for per month fee

I want have two Formula field should work like
End_date      = Start_Date__c + Term__c
Total_Amount = Rate__c * Term__c
*/

/*Formula for End Date formula(Date) Field is : */

IF(ISPICKVAL(Term__c, "12"), ADDMONTHS(Start_Date__c,12),
IF(ISPICKVAL(Term__c, "24"), ADDMONTHS(Start_Date__c,24),
IF(ISPICKVAL(Term__c, "36"), ADDMONTHS(Start_Date__c,36),
IF(ISPICKVAL(Term__c, "48"), ADDMONTHS(Start_Date__c,48),null))))

/*Formula for Total Amount formula(currency) Field is : */

CASE(TEXT(Term__c),
"12", (12* Rate__c) ,
"24", (24* Rate__c) ,
"36", (36* Rate__c) ,
"48", (48* Rate__c) ,
0)

What is test away to rewrite this two formula function that is more dynamic . like i dont' need to set 12,36 ... in my formula. Vamsi
Hi,

You can make use of Value function to convert Text to Number in formulas as below.

VALUE(Text(myPicklist__c))

Hope this helps...!!