Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Trying to calculate formula for discount

Topic Labels: Formulas
Solved
Jump to Solution
1366 3
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. 

Ricardo_da_Cost
6 - Interface Innovator
6 - Interface Innovator

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