Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter 2012 Thousands Separator

(0) ShareShare
ReportReport
Posted on by 1,035

I cannot get the separator comma to work for the millions in the Column Definition Format/Currency Override.  It works fine for the hundreds and thousands but the million digit is just part of the thousands.  When I select the build in Format Override, there is no place to select the separator so that is no help (strangely, in the setting I have selected Display Digit Separators but it does not have any effect).  I have copied the code I use in FRx which works perfectly (#,###,##0; (#,###,##0)) but when I use it in MR 2012, I get the red exclamation mark.  I tried using ###,###,###0.;(###,###,###0.) or #,###,###0.;(###,###,###0.) which MR accepts but in both cases the million separator is not shown.  I also tried the one that works in Excel but it did not work in MR.  What is the right code to use?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Management Reporter 2012 Thousands Separator

    Hi PDT, may I know the specific build number that you have installed?  I also have the same issue but uninstalling/reinstalling did not solve the problem.  Thanks.  

  • Verified answer
    PdT Profile Picture
    1,035 on at
    Re: Management Reporter 2012 Thousands Separator

    After uninstalling and reinstalling MR 2012, the problem was fixed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans