How can you change the color of a cell using beast mode and have the output formatted as a number?

Hi,

I'm trying to format the color of the text and background in a table using HTML similar to what's below:

CONCAT('<div style="background-color:#fccf84; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', SUM(`Variance`), '</a></div>')

The problem is that I want to put dollar signs and comma's in the output but this formats it as text. Is there any way around that?

Jake

Find more posts tagged with

Hi all,

Can anybody help @jakeroberts with their question?

Thanks!

This is not possible, however you can format the number in a dataflow.

CONCAT('$', FORMAT(Amount, 2)) Amount

@jakeroberts, did ptran's reply help you out?