Finance | Project Operations, Human Resources, ...

Rounding Setting Only for One Row in the financial reporting

(2) Share

Report

Posted on by CU16012138-0

All amounts in the financial report should be rounded to 2 decimal places. But some of the rows in the report need to be rounded in other way for example to thousands or whole numbers. How can I set it up? These rounded amounts are printed and also used as the base for the further calculation in next rows. Thanks for your help

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Vahid Ghafarpour 12,202 Super User 2025 Season 2 on at

Like (1)

Report

For rows that need to be rounded differently, use the Format Code column in the row definition. You can enter custom format codes to apply different rounding rules. For example, use #,##0 for whole numbers, #,##0.00 for two decimal places, or #,##0, for thousands.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/analytics/advanced-formatting-options-financial-reporting#example-2-statistical-reports

Was this reply helpful? Yes No
Klara Calabro 18 on at

Like (0)

Report

Thank you VaHiX for your proposal.

From my point of view and according to my tests, this Format code is only for display purpose. The values are displayed rounded, BUT mathematically they remain the same and if this rounded amount is used in another row as a basis for further calculation, the system calculates with the unrounded amount. Is there any other way how to get rounded value which can be used in further calculation?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Rounding Setting Only for One Row in the financial reporting

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Rounding Setting Only for One Row in the financial reporting

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates