Login / Sign up
Table transformations

How to add VAT or markup and round a price

2026-06-20
Task

A price list contains prices without VAT or without markup. The final file needs the price increased by a percentage and then rounded.

Short Answer

In the price column, add two transformations: Increase by % with value 20, then Round.

How to Do It in Eofferix

  1. In the table editor, open the settings of the price column.
    Opening the price column settings in the Eofferix table editor
    The settings button is highlighted under the price column.
  2. In Transformations, add a rule: condition Current value — Any, action Increase by %, value 20.
  3. Add the next rule with action Round. In the current window this action does not need a separate value.
    Rules for increasing a price by a percentage and rounding it
    The price settings contain two rules: Increase by % with value 20 and Round.
  4. Save the column settings.

Before / After

Before

source data
skuprice
SKU-1001999.90

After

result
skuprice
SKU-10011200

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up