Skip to content

Create Rounding Filters

When you switch on Round Prices you have to specify rules for prices filter masks. The following tables give examples of rounding rules you can use and how they affect prices. Your rounding filter must use an asterisk (*) to represent:

  • The first number place to the left that you do not want to explicitly round.
  • Any numbers places to the right of the decimal point (or another number) that you do not want to explicitly round.

For decimal mark, you must use a decimal point symbol (.) in the Rounding Filters, even if your currency uses a different symbol for the decimal mark. For example, if your currency uses a comma (,) as a decimal mark, you must use a decimal point(.) instead of in the Rounding Filter.

Examples for currencies with two decimal places:

If you want to... Rounding Filter Price before rounding Price after rounding
Round up prices to end with .99 *.99 123.12 123.99
3.57 3.99
Round up prices to end with .49 or .99 *.49 123.12 123.49
*.99 3.57 3.99
Round up prices to end with .*9 *.*9 123.12 123.19
3.57 3.59
Round up prices to end with 9.99 *9.99 123.12 129.99
3.57 9.99
Round up prices to end with .97 *.97 123.12 123.97
555.98 556.97
3.57 3.97

Examples for currencies with no decimal places:

If you want to... Rounding Filter Price before rounding Price after rounding
Round up prices to end with 0 *0 23,232 23,240
8,899 8,900
Round up prices to end with 90 *90 23,232 23,290
8,899 8,990
Round up prices to end with 50 or 90 *50 23,232 23,250
*90 23,267 23,290
Round up prices to end with 900 *900 23,232 23,900
2,000 2,900
2,929 3,900

Examples for currencies with three decimal places:

If you want to... Rounding Filter Price before rounding Price after rounding
Round up prices to end with 0.999 *.999 123.123 123.999
3.577 3.999
Round up prices to end with 0.449 or 0.999 *.499 123.123 123.449
*.999 3.577 3.999