TM1 Forum

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

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.