You need to sign in to do that
Don't have an account?
Aaliya Yusufzai
Formula Currency field
Hi,
I'm trying to create a formula field.
If a picklist value is "Monthly", then take the currency field of "Total" and divide that by 12 to show the value
If a picklist value is "Annual", then take the currency field of "Total" and divide that by a number field 1 to show the value
f a picklist value is "SemiAnnual", then take the currency field of "Total" and divide that by a number field 2 to show the value
I'm not sure how to do this.
I'm trying to create a formula field.
If a picklist value is "Monthly", then take the currency field of "Total" and divide that by 12 to show the value
If a picklist value is "Annual", then take the currency field of "Total" and divide that by a number field 1 to show the value
f a picklist value is "SemiAnnual", then take the currency field of "Total" and divide that by a number field 2 to show the value
I'm not sure how to do this.
Your formula will be simply this
OR you can also write the same logic in a different way using nested IFs like below
I would recommend you to go with the CASE approach.
Use the insert field option to use the right API names of the fields.
Kindly mark it as an answer if that works.
All Answers
Your formula will be simply this
OR you can also write the same logic in a different way using nested IFs like below
I would recommend you to go with the CASE approach.
Use the insert field option to use the right API names of the fields.
Kindly mark it as an answer if that works.