I'm having an issue where I'm including a conditional format in a report, but the conditional format is not only being applied to the values that it should be, but also to those values that are "No Data".

For example, I'm coloring data red when it's over a certain percent.

 TYPE=DATA, ACROSSCOLUMN=N1, BACKCOLOR=RED, WHEN=DFWI_RATE GE EVAL_RATE, $ 

This code results in certain cells over 20% and other over 30% to be shown in red. But it's also coloring all my "No Data" cells red.

DFWI_RATE is a D5.2% field.

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

I would suggest moving the test into a COMPUTE or DEFINE, and set a Flag to say Y or N, and have the test also take into account the MISSING data.

The quickest way to solve this is to compute a column which is then used in the stylesheet, something like:

...
COMPUTE CONDITION_RED/A3 = IF DFWI_RATE IS MISSING THEN 'NO' ELSE IF DFWI_RATE GE EVAL_RATE THEN 'YES' ELSE 'NO'; NOPRINT
...
TYPE=DATA, ACROSSCOLUMN=N1, BACKCOLOR=RED, WHEN=CONDITION_RED EQ 'YES', $
...

Well that was just way to easy, thank you both! That's Monday brain for you.

That were I have the advantage, its Tuesday.....

That's one of the first set of posts that I have seen where the first shown was posted one day before the next post!

Waz posted on Tuesday where as Francis posted on Monday, but only a minute later!

That's going to mess with your head!

T

I just entered the pub while he just left.

quote:

I just entered the pub while he just left.

Something you said?

T

Muhahahah.