Skip to content

Add RoundMode to round and fix rounding inconsistency (Decimal uses "half_even", float uses "up") #21800

Open
@Julian-J-S

Description

@Julian-J-S

Description

Problem (edited) ⚠

current round expression has no mode and is inconsistent

  • Decimal: uses "half even"
  • Float: uses "half away from zero"

Why

Depending on the industry (financial, pricing, ...) it is critical to use the "correct" rounding mode.
The two most common are

  • half even / bankers rounding
  • half away from zero / up (e.g. excel)

There are multiple others that can be added in the future.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or an improvement of an existing feature

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions