Hi All:

Have several data columns with $ Values.. I know individually I can color it based on the value.. BUT
is there a way to specify at the DATA level to display any negative number in different color, for example RED..

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

and
TYPE=DATA,COLUMN=THING,COLOR=RED,WHEN=THING LT 0,$
doesn't work for you???

Wow, quick....

Thanks Susannah. Yes It does.. but I was hoping to not use COLUMN..

Thanks

i'm going to resist every temptation to ask 'Why not?'...
ok, if you are willing to xlate your data item from numeric to alpha (use FPRINT for max control), then you can DEFINE a text variable that contains the font color tag surrounding the FPRINTed value.
got it?

quote:

several data columns with $ Values

How to print in red negative numbers?

There are 3 types of identifiers to refer a column.. P,N,C

This message has been edited. Last edited by: Rifaz,

Susannah I have 12 Mons Buckets + total column for 30 rows..
Rifaz, Thanks Tried your approach it works fine but my currency fields are mentioned in subheads

 
"<LDESC1<+0><GOAL_DUMMY<+0><MTD_AMT1<+0><MTD_AMT2<+0><MTD_AMT3<+0><MTD_AMT4<+0><MTD_AMT5<+0><MTD_AMT6<+0><MTD_AMT7<+0><MTD_AMT8<+0><MTD_AMT9<+0><MTD_AMT10<+0><MTD_AMT11<+0><MTD_AMT12<+0><MTD_AMTTOT><+0><BLK_GOAL<+0><BLK_FIMP"

 

Subfoot Condition formatting

Use LE 0 in your conditional formatting.