Field - Decimal Accuracy Issues

Created on 3 November 2023, 8 months ago

Problem/Motivation

Core decimal calculations round larger numbers instead of be exact. This becomes a serious issue when attempting to accomplish basic math functions or when presenting currency values for reporting and basic presentation. Worse, the field validators prevent numbers from being entered or saved. Even if the length is of the field is specified in the field config.

Steps to reproduce

Create a number field of type decimal.
Define the boundaries to be over 32 numbers.

Attempt to save records using numbers from 1 to 32 (and beyond) with decimal values.
See system bork or block values.

Proposed resolution

Expand accuracy and range of validations for larger number sets.

Prevent rounding or "shaving" of values both in the database and on field render.

πŸ› Bug report
Status

Needs work

Version

10.1 ✨

Component
FieldΒ  β†’

Last updated about 17 hours ago

Created by

πŸ‡ΊπŸ‡ΈUnited States emptyvoid

Live updates comments and jobs are added and updated live.
  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

Sign in to follow issues

Comments & Activities

Production build 0.69.0 2024