Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Trying to calculate formula for discount

Solved
Jump to Solution
969 0
cancel
Showing results for 
Search instead for 
Did you mean: 
amber_elane
4 - Data Explorer
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)

amber_elane_0-1693249018713.png

 

1 Solution

Accepted Solutions
Sho
11 - Venus
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}))

 

See Solution in Thread

3 Replies 3
Sho
11 - Venus
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}))

 

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

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