Formatting in reports

[tez]

Hi

I have created both a classic slice & active form report where I am wanting the total values if a negative value to be shown in parenthesis and white font (rather than the typical red). I have changed the formatting of the cells within Excel to use a custom format - I have changed a preset format of $#,##0.00;[Red]-$#,##0.00 to $#,##0.00;[White]($#,##0.00) which works fine when viewing the report in Excel, but when I publish the report up to TM1Web, the formatting disappears & the report shows a basic format of a general number, so no $ sign, commas, or 2 decimal places, with a minus sign rather than parenthesis.

The weird thing is if I change the colour White in my custom formatting formula to Green or Blue etc, the formatting shows as I want in TM1Web. It seems to have a problem with the colour white.

Can anyone help?

Thanks

[tomok]

Conditional formatting, for the most part, translates pretty well between Excel and TM1Web. That being said, not everything you do in Excel, formatting-wise, is going to translate. The only way you're going to know what works for you is going to be trial and error. Sorry, been there done that a number of times. Be patient, you'll eventually find something that gives you close to what you want.