HELP WITH COLORMIX IN A COLUMN

[antoniodneto]

Hey guys How Can I create a COLORMIX function to work on my following table:

I'm trying to make a gradient over the third column, colloring row by row.

My expression is

Num((SUM({<DATA={'$(=Max(DATA))'}>}RISCO_TOTAL)
-
SUM({<DATA={'$(=AddMonths(Max(DATA),-12))'}>}RISCO_TOTAL))
/
SUM({<DATA={'$(=AddMonths(Max(DATA),-12))'}>}RISCO_TOTAL),'#.##0,00%')

[Channa]

try ColorMix function it will allow gradient

[antoniodneto]

Hy Channa, that's what I'm trying to do. I don't know how to use ColorMix on my expression.

Tks!

[Channa]

colormix(IF(Sales)<100,Red(),White())

[antoniodneto]

Hi Channa,

Actually I can't set 100% as my indicator because the percetuals can be change.

It should colour auto from the colors.