audrey_mitch@horizonblue.com

HTML - negative $$ in red - can anyone assist?

Discussion created by audrey_mitch@horizonblue.com on Jun 4, 2018
Latest reply on Jun 5, 2018 by igeorge@apptio.com

I have created a few custom reports with HTML and am attempting to have the negative numbers report in red automatically.  The current formula I'm using is:

 

<b><center><font size="2">Variance:  &nbsp&nbsp<%=NumberFormat(Forecast Variance, "#,###")%><Center>

 

I've tried to utilize the formula below but the $$ don't report:

 

<b><center><font size="2">Variance: </font>&nbsp&nbsp<%=NumberFormat(Forecast Variance, "<font color="black">#,###</font>")%><Center></b>

 

Does anyone have any suggestions? Appreciate the assistance.

Best,
Audrey Mitch

Outcomes