Help

Calcultate discount based on single field

Topic Labels: Formulas
Solved
Jump to Solution
2833 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastien_Burge
4 - Data Explorer
4 - Data Explorer

Hi,

I need some help to do something…

1/I have a column with a price
2/ I have a column with a Single Select option, and a list of discounts (10%,15%,20%,30%)

I would like to create a 3rd column, with a formula which gives me the total discounted price, based on the discount which has been selected.

So if : Column B has a total of $100
Column C has 10% selected
The new column D should show me $90

I don’t know how to create a formula which will calculate the discounted amount based on the selected field.

I would be great to have some help on that! :slightly_smiling_face:

Thanks,
Sébastien

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Create a formula field with this formula:

{price} - VALUE(SUBSTITUTE({discount},'%',''))/100 * {price}

What the formula does: removes the percent symbol from the single select field, makes sure the remaining text is treated as a number, converts it to a decimal value, multiplies that decimal by the original price, then subtracts it from the original price.

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Create a formula field with this formula:

{price} - VALUE(SUBSTITUTE({discount},'%',''))/100 * {price}

What the formula does: removes the percent symbol from the single select field, makes sure the remaining text is treated as a number, converts it to a decimal value, multiplies that decimal by the original price, then subtracts it from the original price.

Sebastien_Burge
4 - Data Explorer
4 - Data Explorer

Thanks a lot for your reply Kamille ! It worked :slightly_smiling_face: