News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter--C...

Microsoft Dynamics GP (Archived)

Management Reporter--Comma with No Decimal Places

(1) Share

Report

Report

Posted on by Community Member

Hello:

I'm trying to have our balance sheet in Management Reporter 2012 CU13 display no decimal places but have a comma for thousands and millions.

What "custom" format do I place in the Column Definition to accomplish this?

Thanks!

John

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

RE: Management Reporter--Comma with No Decimal Places

Thanks, so much, Sandip!

John
Community Member on at

Like (0)

Report

RE: Management Reporter--Comma with No Decimal Places

Thanks, Matt! That's just what I needed!!!

John
Verified answer

MattPaulen 6,912 on at

Like (1)

Report

RE: Management Reporter--Comma with No Decimal Places

You don't really need to have a custom format for that unless I am missing something. All you need is to set the report to round to whole dollars on the Settings tab and rounding precision.
Suggested answer

sandipdjadhav 18,297 on at

Like (0)

Report

RE: Management Reporter--Comma with No Decimal Places

Hi John,

Try this one ###,###,###0.;(###,###,###0.);

https://community.dynamics.com/gp/f/32/t/84011

Hope this work for you.

Thanks Much

Sandip Jadhav

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans