You need to sign in to do that
Don't have an account?
sessu
HI
Hi I need to create a formula field to calculate amount to be paid based on month, and amount text field, from month picklist (any month i can select, amount need to be calculate from selected month till next year of march) based on both field, fees to be paid field needs to be filled.
3 fields
amount--text
joining month---picklist
Fees to be paid---- text
all 3 fields,belongs to same object.
Please help me to write a formula for this.
Hi,
You can use the CASE function to know the selected month in number refer the below example as reference:
Text(CASE(TEXT(monthpicklist__c),
"January",1,
"February",2,
"March",3,
"April",4,
"May",5,
"June",6,
"July",7,
"August",8,
"September",9,
"October",10,
"November",11,
"December",12,0))
Can you explain in detail with an example so that I can create a formula.
Your explaination is really hard to follow, it would be a lot better if you could pos an example with the actual caluculation you're trying to perform in your formula, like this:
Do you still need help with this or are you all set?