How to retain % in Excel formatting after BPC Refresh?

[Former Member]

Hello everyone

I've created a BPC report which the first row is Gross Margin %. I changed the formatting of the cell to display as %.

Everytime I refresh the report, the format changed from 1% to 0.01, 4.4% to 0.044, 3.33% to 0.03333 etc....

It's annoying. How do I fix it as % each time I refresh?

I cannot use the Dynamic Formatting because it will apply to ALL cells, which I don't want, I only want it to apply to Gross Margin row only.

[former_member186338]

Hi Edmund,

If your report is static and you don't use formatting sheet then simply clear:

Vadim

[former_member186338]

P.S. The same can be achieved with proper options of the formatting sheet: use Formatting on specific member cell.