Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Rounding to thousands, millions and billions with format overrides

Rounding to thousands, millions and billions with format overrides

  • Comments 3

The Report Definition in Management Reporter has options that allow you to round the entire report to options such as whole dollars, thousands, millions and more. But sometimes you don't want an entire report rounded, you want a specific row or column rounded. You can accomplish this with Custom format overrides.

In the example, there are four rows, and each one has a different custom format override applied to it. The comma is used for scaling and allows the single row to round to that amount.

When you generate the report, the rows with the rounding applied using the custom format override will show appropriately.

For ideas and information on how you can create custom format overrides visit http://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
  • Hello, I attempted to do this but as soon as I enter the "@" sign, the custom option will not allow me to save.

    Any help?

  • Thank you for this info. Question. what if I also have a format override in one  column definition and setting the column as % format override (I also have another column showing dollar amount only). It looks like if i have a format override in the column definition, the row still takes precedence. any ideas how to force everything in a column to be in %?

  • Jeff,

    Can you describe the report or send it to me? Some times depending on the override you can get it to work, and some times the combination won't. For example, rounding you can use some of the row and column and report settings to get around it. If you want to share it send to aolson@microsoft.com

Page 1 of 1 (3 items)