Mgt Reporter: Format Override single "cell"

(0) Share

Report

Posted on by ldub

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

All responses (2)

Answers (0)

serbach 571 on at

Like (0)

Report

RE: Mgt Reporter: Format Override single "cell"

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
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Mgt Reporter: Format Override single "cell"

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!!!