Dynamics 365 ERP System Calculation: The digits after the decimal point were erased, but I want to round them up.

Hi FU Maggie

Did you have a chance to check Quick Assist's response? If it does not resolve your issue, you should raise the matter via the Dynamics community for further support (https://community.dynamics.com).

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Use an explicit rounding function in the calculation instead of relying on the default behavior, which is truncating/standard rounding.

In Dynamics 365 Finance and Operations Electronic Reporting (ER), use:

ROUNDUP(number, decimals)

For the example where the division result is 2.5 and the requirement is to always round up to the next integer:

ROUNDUP(2.5, 0)

This returns 3 because ROUNDUP always rounds away from zero to the specified number of decimal places. Setting decimals to 0 rounds to a whole number.

If the result is a calculated expression, wrap that expression in ROUNDUP, for example:

ROUNDUP( field1 / field2, 0 )

This ensures any decimal result (2.1, 2.5, 2.9, etc.) becomes 3.

If the requirement is to round down instead (truncate toward zero), use ROUNDDOWN(number, 0). If standard rounding (to nearest, with banker's rounding) is needed, use ROUND(number, decimals).

References:

• ROUND ER function
• ROUNDUP ER function
• ROUNDDOWN ER function