Can I show positive (instead of negative) numbers in red?

Alex_K

I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.

Is there a way for me to have only one row be opposite of normal with positive numbers in red?

MichelleH

@Alex_K You can do this by adding HTML to your metric in a beast mode like this:

case 
  when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>')
  else concat(`Sales`,'')
end

Here is a knowledge base article on how that works: https://domo-support.domo.com/s/article/360043430033?language=en_US

pauljames

@Alex_K Hey there! Have you tried this?

MarkSnodgrass

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.

GrantSmith

Have you looked into utilizing color rules so that if it's < 0 it's green and > 0 it's red?

https://domo-support.domo.com/s/article/360043428813?language=en_US

MichelleH

@Alex_K You can do this by adding HTML to your metric in a beast mode like this:

case 
  when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>')
  else concat(`Sales`,'')
end

Here is a knowledge base article on how that works: https://domo-support.domo.com/s/article/360043430033?language=en_US

pauljames

@Alex_K Hey there! Have you tried this?

MarkSnodgrass

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.