range

[soniasweety]

Hi all,

i want to show the bg colour based on below range

Which ever  code  is less than 97% or >103%  those should bg color red

With in that green range  ( 97% -103%)   -- stright table

[ i need the rate column values should show in %  like  100.00%]

[Anonymous]

to Show the rate in % you may define the Format under tab Settings/Document properties/number

but rate will Show as 10000%

I wopuld prefer to define rate as Expression, there you can define only(rate/100) and under tab number you may format as percent

for Background colour ypu may define background Color

I would not Color all values. only those rates which i want Attention for user should be colored

(but some customer want all values colored)

[soniasweety]

thanks for your reply.. but if i add as expression  rate/100  its showing only some values as percentage rest it is showing null,   but for that id's i have rate value.

[HirisH_V7]

Hi

Please check using below expression in, Background color.

=IF(Num(rate/100,'#,##0.00%')>'97.00%' and Num(rate/100,'#,##0.00%')<'103.00%',lightGreen(),lightREd())

PFA

HTH

Hirish

[Frank_Hartmann]

maybe like attached

hope this helps

[soniasweety]

Oh you are done on code column    i need in  rate column .. i will manage that,

but one more thing here..  i want to show  two KPI text objects with  that green count and red count  how can i do that?

[soniasweety]

yes its looks good.  but i need to change the expression like below

and i need to convert the  rate in script only.

=IF(Num(rate,'#,##0.00%')>'97.00%' and Num(rate,'#,##0.00%')<'103.00%',lightGreen(),lightREd()) 

[andrey_krylov]

Like this?

[Frank_Hartmann]

textbox1(red):

=sum(aggr(sum(if(rate>103 or rate < 97,1,0)),code))

textbox2(green):

=sum(aggr(sum(if(rate>103 or rate < 97,0,1)),code))

[soniasweety]

its looks exactly what i need ,.. but if you export the table  im getting the wrong count for green .. red it is showing correct

how come it is like that? did i miss anything?