Hi, I have a table that I would like to format so that anything over 0 is red and less is green. I have created the beast mode below but I am not sure how to amend it so that the result is a percentage that also creates a total in the total row rather than a count

CASE WHEN (sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago)

0

then concat('<div style="color: #ff0000">',(sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago) ,'</div>')

else

concat('<div style="color: #00ff00">',(sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago) ,'</div>')

end

Any help appreciated!