Login / Sign up
Table transformations

How to multiply quantity by price and get a line total

2026-06-20
Task

A table contains qty and price. The final file needs a per-row amount in line_total.

Short Answer

Create line_total from price and add a Multiply transformation with value {qty}.

How to Do It in Eofferix

  1. Create the final line_total column, use price as the source, and open the settings of this column.
    Opening the line_total column settings in the Eofferix table editor
    The settings button is highlighted under the final line_total column.
  2. In Transformations, add a rule: condition Current value — Any, action Multiply, value {qty}.
    Rule that multiplies price by qty in line_total settings
    In line_total settings, the price value is multiplied by the qty column through {qty}.
  3. Save the column settings.

Before / After

Before

source data
skuqtyprice
SKU-10013250

After

result
skuqtypriceline_total
SKU-10013250750

Process data faster with Eofferix

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

Sign up