Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%')
try ColorMix function it will allow gradient
Hy Channa, that's what I'm trying to do. I don't know how to use ColorMix on my expression.
Tks!
colormix(IF(Sales)<100,Red(),White())
Hi Channa,
Actually I can't set 100% as my indicator because the percetuals can be change.
It should colour auto from the colors.