web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Mgt Reporter: Format O...
Microsoft Dynamics GP (Archived)

Mgt Reporter: Format Override single "cell"

(0) ShareShare
ReportReport
Posted on by ldub 55

I need to format only certain rows of certain columns as %.  Broad use of format override in the column or row definitions applies the override too broadly.  How do I format as follows?

$230      $12.10
$560 10%
$890 15%
$120 $1.20
$450 $1.00

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,416 on at

    This is out of box in MR. We can not set specific format to certain rows of certain columns in Management Report. It will allows us to set format for entire columns.

    Hope this helps!!!

  • serbach Profile Picture
    serbach 571 on at

    LDUB,

    I've been wrestling with formatting as well. "Format Overrides" in the Row Definition take precedence over "Format / Currency Overrides" in Column Definitions. E.g., if the Format Override of the Row Definition is #,##0;(#,##0);- to override the 0 text, but you want a percent format in the last column of your Column Definition like ###0.0%;(###0.0%);, then the Row Definition Format Override will take precedence, and your percents will be 0 for any percent < 50%, and 1 for percents between 50% and 150%...clearly not desirable!

    What I might try in your situation is to put the percentages in different columns than the dollar values...though you've probably already considered that. Then an entire column will be either formatted as currency or as percents.

    Sincerely,

    Steve Erbach
    WOW Logistics Company
    Appleton, WI

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans