APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change font colour to red if value less than zero

510257Sep 12 2006 — edited Sep 15 2006

Please forgive as I am not sure if this should go to the SQL or Application Thread..
My questions is regarding SQL in Application Express

I want to display my field (ADJ (INCL GST) in a red colour if its value is less than zero

here is SQL code

select "TW_BILL_ADJ_DATA"."CUSTOMER" as "CUSTOMER",
"TW_BILL_ADJ_DATA"."ORIGINATER" as "ORIGINATOR",
CASE WHEN (CREDITDEBIT) = 'Credit' THEN (0 - ADJUSTMENT_INCL_GST) ELSE ADJUSTMENT_INCL_GST END "ADJ (INCL GST)"
from TW_BILL_ADJ_DATA

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2006

Added on Sep 12 2006

#apex-discussions

3 comments

514 views