Task
price contains decimal values. The export needs price_99: the rounded price minus 0.01.
Short answer
Create price_99 from price, add Round, then Subtract → 0.01.
How to do it in Eofferix
Open the settings of the output
price_99column and selectpriceas the source.
The outline marks the column where the new price is built. In
Transformations, add two rules:Any→Round; thenAny→Subtract→0.01.
The first rule rounds the price; the second subtracts 0.01.Save the template and run the transformation on the final step.
Before / after
Before
source data| sku | price |
|---|---|
| SKU-100 | 1240.20 |
| SKU-200 | 999.50 |
After
result| sku | price_99 |
|---|---|
| SKU-100 | 1239.99 |
| SKU-200 | 999.99 |