Hi everyone,
I propose adding a feature to handle decimal precision in Board, especially for totals and calculations. Currently, floating-point errors can cause totals to display as 0.0000000000xxx instead of 0, which leads to issues in data entry and result splits.
Suggested Solution:
Allow users to set precision limits (e.g., 2 or 3 decimals) in specific cubes to avoid floating-point discrepancies. This would ensure that rounding is applied consistently at both the leaf and total levels.
Additionally, when small errors like 0.00000000001 are detected, treat them as 0 automatically, preventing incorrect data entry and split issues.
