The source column contains positive numeric prices without a currency symbol. The target must follow the “nearest integer minus 0.01” policy while blank, zero, and invalid values remain blank.
Validate the format and positive value before any calculation, select Round—the table editor defaults to the nearest integer with step 1—subtract 0.01, and clear the final value when the result is non-positive.
How to Do It in Eofferix
Add or open the target
price_99column and selectpriceas its source. These names are examples; use the actual fields in your profile.Before the calculations, add Any → Trim spaces at edges, then Not a regular expression with
^\d+(?:[.,]\d+)?$→ Do not export field, and Less than or equal with0→ Do not export field.
Invalid and non-positive inputs leave the final price value empty; valid prices are rounded to the nearest integer and reduced by 0.01. Add Any → Round. In the table editor this action defaults to the nearest integer with step
1; then add Any → Subtract with0.01, and finish with Less than or equal and0→ Do not export field.Apply the rules and inspect rows with
.20,.50, and.80fractions, as well as zero and invalid text, in the preview. Then run a small test export and open the downloaded file. Use the column only when both results match the table below.
price and price_99 are example names. The source must contain a clean number without a currency symbol or code. This algorithm does not always reduce a price: a fraction of .50 or more can produce a result greater than the source value.Expected Result
| Source price | Result | Why |
|---|---|---|
1240.20 | 1239.99 | 1240.20 rounds to 1240, then 0.01 is subtracted. |
999.50 | 999.99 | 999.50 rounds to 1000, then 0.01 is subtracted. |
1240.80 | 1240.99 | 1240.80 rounds to 1241, then 0.01 is subtracted. |
240.00 | 239.99 | 240 rounds to 240, then 0.01 is subtracted. |
0 | blank | A non-positive source price leaves the final price_99 value blank before calculations. |
not-a-price | blank | Invalid text must not become -0.01. |
Checks Before Export
- Use Round: in the table editor this action rounds to the nearest integer with step
1, so there are no separate mode or step fields to select. - Validation runs before the first mathematical action.
- Zero, blank input, and invalid text remain blank.
- The pricing policy is approved by your business and accepted by the destination channel.
Limits of This Method
- A fraction of
.50or more can move upward to the next.99ending. - For example,
0.49would become non-positive and is cleared, while0.50becomes0.99. - “Always down to .99” and “always up to .99” are different algorithms and must not be described by this rule chain.