Expression Attributes and column totals

[mikecrengland]

Hello All -

I'm using Expression Attributes to conditionally color columns in a straight table. It's a simple greater than or less than 'If' statement (>20, green or <5, red). Is there a way to not color the expression total?

I'm using v12.1 SR7.

Thanks!

mike

[vinieme12]

The total row rowno() is 0 , so add another condition to check for the total row as below

if(Rowno()<>0,

          if ( expression>20,green(),

                         if(expression<5,red())

                    )

     )

[sergio0592]

It should works with

=if(Dimensionality()=1,if(sum([Group1 trips])>20,green(),if( sum([Group1 trips])<5,red())),Black())

[mikecrengland]

Hello Jean-Baptiste,

Thank you for the suggestion, but it unfortunately removed the color completely.

mike

[mikecrengland · Accepted solution]

This was so close! the <> 0 didn't work, so I tried > 0 and, bingo, no more color.

Thanks!

[sergio0592]

I have tried with a sample and it works. Try to add a dimensionnality() expression for see what it returns.