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%]

[andrey_krylov]

Yes, I should to aggregate the count as Frank did. My exp counts the table rows, not chart

[soniasweety]

hi franky_h79     if i export the table why it is showing only  137 green ? instead of 164?

[andrey_krylov]

Sony, if you add RowNo() to the load script and show this field in the chart then there will be 175 rows instead of 137

test:

LOAD code,

     rate,

     amount,

     RowNo() as RowNo

FROM

color.xlsx

(ooxml, embedded labels, table is Document_TB02);

[Frank_Hartmann]

see attached.

hope this helps

[soniasweety]

both  solutions working fine... once i check with real data  i will close this thanks.

[soniasweety]

Hi franky_h79

andrey.krylov

im not able to see the red count  ... what is the issue  .PFA

[Frank_Hartmann]

see attached.

by the way what about the discussion from yesterday? did you find the solution, because you didnt respond to my suggestion?

still facing issue-Need urgent help

[soniasweety]

i have overall count is  169

but in your attached file red count showing5 correct but green count is showing 169  it is wrong it should show 164

export the excel and see the count,

-- yesterday issue not tested because in  Production we are not doing any changes till 12 th of this month

[Frank_Hartmann]

see attached

[soniasweety]

i have changed the expression it is working    thank you