Issue Formatting Totals

[caio_caminoski]

Hi guys,

I was working on a table with a few conditional formatting rules and I came across a problem.

As you can see in the image below, my total row is also getting afected by the format conditions I have used for my data.

I have tried a few rules to get able to avoid this behavior, but with no success. I also tried "Custom Format Cell" and, as I expected, didn't work.

Is there any workaround?

Thanks in advance!

[afurtado · Accepted solution]

Hi.

maybe you can use Dimensionality().

if(Dimensionality()=0,rgb(x,x,x),.....)

Could you put a sample model?

Best,

Alessandro Furtado

[caio_caminoski]

Beautiful solution! I didn't know about this function!

Valeu Alessandro! Abraço

[afurtado]

grande abraço