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

shephaliHi Sudhir Narayanaswamy, 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

Bryan JamesHey Sudhir,

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.

shephaliHi Sudhir Narayanaswamy, 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

shephaliPlease dont forget to mark it as solution if you get your answer. GMASJThanks Shephali for you reply Just want to know I tried below usign case does his have any issue let me know.
Thanks

Sudhir

shephaliIt wont work as picklist value must be first converted to text .