# Trying to calculate formula for discount

Topic Labels: Formulas
Solved
970 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi there,

I am trying to calculate a formula for a discount. The discount category is single select (10% or 20%).

I want to calculate what the total revenue will be with the selected discount. The current formula for revenue is (price * quantity)

1 Solution

Accepted Solutions
11 - Venus

Hi @amber_elane ,

The Single select field returns a string, if it is a string such as 10% or 20%, it can be converted to a number with the VALUE function.

``{Revenue}*(1-VALUE({Disucount}))``

3 Replies 3
11 - Venus

Hi @amber_elane ,

The Single select field returns a string, if it is a string such as 10% or 20%, it can be converted to a number with the VALUE function.

``{Revenue}*(1-VALUE({Disucount}))``

4 - Data Explorer

Hi @Sho thank you so much! That worked perfectly.

5 - Automation Enthusiast

Just to add onto this... obviously the "%" should be removed from the string before using the VALUE function.