Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos 8.1 conditional formatting

Status
Not open for further replies.

pcoladeb

Technical User
Jan 22, 2007
11
US
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
 
Is any part of it working, or does all of the code fail?
 
Code:
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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top