Cognos 8.1 conditional formatting

[pcoladeb]

Can't seem to get negative numbers to play in my conditonal formatting. Here is one of them. What am I doing wrong?

if ( [ECM Tracker].[RTC Under Executing] between 0 and
-.050 ) then ( 'Green') else if ( [ECM Tracker].[RTC Under Executing] between -.051 and -.1 ) then ( 'Yellow' ) else if ( [ECM Tracker].[RTC Under Executing] > -.1 ) then ( 'Red' ) else ( 'None' )

I've tried reversing number, doing (.5) instead of -.5. No joy.

Any help would be appreciated.

Thanks,
Deb

 

[UcfMike]

Is any part of it working, or does all of the code fail?

 

[blom0344]

if ( [ECM Tracker].[RTC Under Executing] between 0 and
-.050 ) then ( 'Green') else if ( [ECM Tracker].[RTC Under Executing] between -.051 and -.1 ) then ( 'Yellow' ) else if ( [ECM Tracker].[RTC Under Executing] [b][COLOR=red]>[/color][/b] -.1 ) then ( 'Red' ) else ( 'None' )

The '>' should be '<' in any case , otherwise you have an internal conflict within the if then else.
Did you attempt (-1*(1/20)) instead of -.050?

Ties Blom

 

[pcoladeb]

Thanks so much for the help.

You said, Did you attempt (-1*(1/20)) instead of -.050?
I said, it works great when I do it the way you said.

Deb