DECODE(SIGN(TEST_RAG_BTNET.R-(0.2*50)),-1, '<p style="BACKGROUND-COLOR: GREEN"> ' || TEST_RAG_BTNET.R || ' </p>',(DECODE(SIGN(TEST_RAG_BTNET.R-(0.5*50)),-1,'<p style="BACKGROUND-COLOR: RED"> ' || TEST_RAG_BTNET.R || ' </p>','<p style="BACKGROUND-COLOR:#FFFF00"> ' || TEST_RAG_BTNET.R || ' </p>')))


TEST_RAG_BTNET- table name

R is the column name

0.2 *50 is to take 20% of 50

have to write a decode statement in which.. if the data is greter than 50% data should be in red color..and if grater tahn 80 .. blue and less tahn 50 then green

this happens perfectly..

but if the data is dot 50% .. it shows red
but i want it in green
this is my problem