General Formatting query.

[#1]

Hello All,

I am trying a simple background colour expression, which doesnt seem to be working and hope someone could help me with it.

=if("=$[KPI_Conduit]">1, LIGHTGREEN(),WHITE())

I have a straight table on which I have a KPI_Conduit as a Dimension, I want the row to be highlighted when the user clicks on any field under the KPI_Conduit in the straight table. This expression is working to some extent, but when I clear All then all the fields turn Green...

Thanks,

Mady

[lironbaram]

hei try

if(getselectedcount(KPI_conduit)>0,lightgreen(),white())

[#3]

Hello,

unfortunately its still turning the whole dimension field GREEN when I click on 1 field.But I think the expression is wrong as it turns everything light green because its >0 when you click on something.

Any more suggestions please I also tried :

if(getselectedcount(KPI_conduit)>0 and getselectedcount(KPI_conduit)<=1,lightgreen(),white())

Thanks in Advance,

Mady

[lironbaram]

hei mady

can you post example

i'll get better understanding of the problem

[deepakk]

hi,

Try this code.

if(getselectedcount(KPI_conduit) =1, lightgreen(),white())

Deepak