You need to sign in to do that
Don't have an account?
Formula Calculation
Hi
We have a requirement to write a formula field for calulating below details are mentioned as follows.
1. Unit of Measure ( Which is pick list holds Year/Month/Days)
2. List Price
3. Quantity
4. Subscription Term
Here Subscription Term is dependent on Unit of Measure
if Unit of Measure = Year it will populate ( 1 to 5)
if Unit of Measure = Month it will populate ( 1 to 12)
if Unit of Measure = Days it will populate ( 1 to 31)
Based on the above value I need to build a formula field
IF Unit of Measure = Year = ( List Price * Year * Quantity )
IF Unit of Measure = Month = ( List Price / 12(Months in year) * Quantity )
IF Unit of Measure = Days = ( List Price / 365(Days in year) * Quantity )
Please suggest me how to get this formula
Thanks
Sudhir
Using the field depency yuo can easily get the following :
Here Subscription Term is dependent on Unit of Measure
if Unit of Measure = Year it will populate ( 1 to 5)
if Unit of Measure = Month it will populate ( 1 to 12)
if Unit of Measure = Days it will populate ( 1 to 31) .
After that try the below formula to calculate :
Thanks
shephali
All Answers
This should be able to be accomplished using a CASE in the advanced formula editor.
You can use this link to see how Salesforce likes to use them.
Using the field depency yuo can easily get the following :
Here Subscription Term is dependent on Unit of Measure
if Unit of Measure = Year it will populate ( 1 to 5)
if Unit of Measure = Month it will populate ( 1 to 12)
if Unit of Measure = Days it will populate ( 1 to 31) .
After that try the below formula to calculate :
Thanks
shephali
Thanks
Sudhir