---
title: Numerical Variable
description: Numerical Variable
---

[Skip to content](https://support.dotidot.io/en/hc/en-us/articles/360018844591-numerical-variable#main-content)

[![Logo\_dark](https://support.dotidot.io/hs-fs/hubfs/Logo_dark.png?width=150&height=35&name=Logo_dark.png)](https://www.dotidot.io/)

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)

Open main navigation

Close main navigation

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)
- [Contact us](https://www.dotidot.io/contact)

[Contact us](https://www.dotidot.io/contact)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Dotidot knowledge base](https://support.dotidot.io/en?hsLang=en)
2. [Data Sources](https://support.dotidot.io/en/data-sources?hsLang=en)
3. [Variables](https://support.dotidot.io/en/data-sources?hsLang=en#variables)

# Numerical Variable

If you are not much of a reader, you can watch the webinar where our Marketing Specialist Marek will explain everything you need to know about Numeric variables:

<iframe class="hs-responsive-embed-iframe" height="315" src="https://www.youtube.com/embed/sa8dtKvfQ1o?si=U1PVToxjQEF6KRpx" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%; border: none;" width="560" allowfullscreen data-service="youtube"></iframe>

Here is a list of formulas used in the video: 

**VAT**  
Base Price \* VAT Rate  
**Example:** If the base price is $100 and VAT is 20%, then:  
VAT = 100 \* 0.20 = $20

 

**Extract VAT from Total Price**

Final Price - (Final Price / (1 + VAT Rate))

**Example:** If the final price is $120 and VAT is 20%, then:

VAT = 120 - (120 / (1 + 0.20)) = 120 - 100 = $20

 

**Base price**

Final Price / (1 + VAT Rate)

**Example:** If the final price is $120 and VAT is 20% → Base Price = 120 / (1 + 0.20) = $100

 

**Fixed discount**

Original Price - Sale Price

**Example:** If the original price is $150 and the sale price is $120, then:

Discount = 150 - 120 = $30

 

**Discount %**

((Original Price - Sale Price) / Original Price) \* 100

**Example:** If the original price is $150 and the sale price is $120, then:

Discount % = ((150 - 120) / 150) \* 100 = (30 / 150) \* 100 = 20%

 

**ROAS**

Revenue / ad spend

**Example:** If revenue is $5,000 and ad spend is $1,000, then:

ROAS = 5000 / 1000 = 5 (meaning you earn $5 for every $1 spent on ads)

 

**ROAS in %**

(Revenue / Ad Spend) \* 100

**Example:** If revenue is $5,000 and ad spend is $1,000, then:

ROAS % = (5000 / 1000) \* 100 = 500%

 

**CPA**

Ad Spend / conversions

**Example:** If ad spend is $1,000 and you got 50 conversions, then:

CPA = 1000 / 50 = $20 (meaning it costs $20 to acquire one customer

 

**Conversion rate**

(Conversions / Clicks) \* 100

**Example:** If you have 500 clicks and 50 conversions, then:

Conversion Rate = (50 / 500) \* 100 = 10%

 

**Fixed profit margin**

Revenue - COGS

**Example:** If revenue is $10,000 and COGS is $6,000, then:

Profit = 10,000 - 6,000 = $4,000

 

**Profit margin %**

((Revenue - Cost) / Revenue) \* 100

**Example:** If revenue is $10,000 and total cost (COGS) is $6,000, then:

Profit Margin % = ((10,000 - 6,000) / 10,000) \* 100 = (4,000 / 10,000) \* 100 = 40%

 

Creating your own numerical variables doesn’t differ very much from creating the text ones – the name and input text are fundamental here as well. What is an additional feature, though, is mathematical operations.

![Sni\_mek\_obrazovky\_2023-03-21\_v\_12.59.16.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8147597668508.png)

As usual, choose such a name for your variable that lets you know what value it gives back to you.

 

![Sni\_mek\_obrazovky\_2023-03-21\_v\_13.00.00.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8147597617052.png)

**EXAMPLE 1:** Your data source features only prices with VAT not included, and you’ve decided to create a variable that does include VAT. The equation will look like this – *price\*1.21*.

 

![Sni\_mek\_obrazovky\_2023-03-21\_v\_13.01.09.png](https://support.dotidot.io/hubfs/Knowledge%20Base%20Import/8147597611804.png)

Enter the equation as your **input text** **(1.)**. The preview will show you the supplemented equation **(2.)** as well as its result **(3.)**.

You can read more about variables on our [blog](https://blog.ppcbee.com/en/articles/105-working-with-variables).

- [Getting started with Dotidot](https://support.dotidot.io/en/getting-started-with-dotidot?hsLang=en)
- [Data Sources](https://support.dotidot.io/en/data-sources?hsLang=en#main-content)

    - [Data sources types](https://support.dotidot.io/en/data-sources?hsLang=en#data-sources-types)
    - [Variables](https://support.dotidot.io/en/data-sources?hsLang=en#variables)
    - [Data enrichment](https://support.dotidot.io/en/data-sources?hsLang=en#data-enrichment)
    - [Feed exports](https://support.dotidot.io/en/data-sources?hsLang=en#feed-exports)
- [Campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#main-content)

    - [DSA campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#dsa-campaigns)
    - [Assets](https://support.dotidot.io/en/campaigns?hsLang=en#assets)
    - [Meta campaigns](https://support.dotidot.io/en/campaigns?hsLang=en#meta-campaigns)
    - [Keywords](https://support.dotidot.io/en/campaigns?hsLang=en#keywords)
- [Product Analytics](https://support.dotidot.io/en/product-analytics?hsLang=en)
- [Image Editor](https://support.dotidot.io/en/image-editor?hsLang=en)
- [Pricing and billing](https://support.dotidot.io/en/pricing-and-billing?hsLang=en)
- [Tips for using the app](https://support.dotidot.io/en/tips-for-using-the-app?hsLang=en)
- [FAQ](https://support.dotidot.io/en/faq?hsLang=en)

- [Home](https://www.dotidot.io/)
- [Webinars](https://www.dotidot.io/webinars)
- [Pricing](https://www.dotidot.io/pricing)
- [Blog](https://www.dotidot.io/blog)
- [Company](https://www.dotidot.io/about)

# Dotidot

<https://www.facebook.com/dotidot.official> <https://www.instagram.com/dotidot_official> [mailto:info@dotidot.io](mailto:info@dotidot.io)

Copyright © 2026, Dotidot