- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 28, 2023 11:58 AM
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)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 28, 2023 04:15 PM
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}))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 28, 2023 04:15 PM
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}))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 29, 2023 09:04 AM
Hi @Sho thank you so much! That worked perfectly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 31, 2023 02:45 AM
Just to add onto this... obviously the "%" should be removed from the string before using the VALUE function.
