You need to sign in to do that
Don't have an account?
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.
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.
You can make use of Value function to convert Text to Number in formulas as below.
VALUE(Text(myPicklist__c))
Hope this helps...!!