How to conditionally format the total row in a table?

[aamer007]

Hi Community,

I am trying to conditionally format the total row in my table.

I have a table in QLIK SENSE, and I want to color the TOTAL row in it. I have tried with function.
Isnull(row()) and dimensionality().
and also use other expression for achieving Total color.
my expression
= If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241))

but none of these seems to work.
my requirement is that total should be in red when values are in -ve and should be in green when values are in +ve.
For e.g The value of Total or -90.4% should be in Red.

Pls find attached snapshot for your reference.

Can someone help me in this?

[Kushal_Chawda]

@aamer007  share your  qvf file showing that it is not working