When '0' is specified for the Number of Decimal Places to Round, values are not calculated correctly

Article Number:040268

The "Number of Decimal Places to Round" setting and the "Rounding" setting specified in the Misc Settings are applied to values in formula as well.

Example of field settings
Field Name and Field Code Field Type Formula
Tax-excluded price (tax_excluded_price) Number -
Tax-included price (tax_included_price) Calculated tax_excluded_price*1.1

In this example, if you enter "100" in the Tax-excluded price field, following values are displayed.

  • If you specify "2" as the Number of Decimal Places to Round, "110" is displayed in the Tax-included price field.
  • If you specify "0" as the Number of Decimal Places to Round, "100" is displayed in the Tax-included price field.
    * Formula for the Tax-included price field is "tax_excluded_price*1".

If you have specified "0" as the "Number of Decimal Places to Round", and want to display "110" in the "Tax-included price" field, you need to set the formula for the "Tax-included price" field as "tax_excluded_price*110/100".