Values are not calculated correctly when "0" is specified for the "Number of decimal places to round"
The Number of decimal places to round and Rounding settings specified in Misc settings are also applied to values in formulas.
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,"100" entered in the "Tax-excluded price" field will be displayed as follows.
- If "2" is specified as the Number of decimal places to round, "110" will be displayed in the "Tax-included price" field.
- If "0" is specified as the Number of decimal places to round, "100" will be displayed in the "Tax-included price" field.
* The 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".