Skip to Content
0
Former Member
Feb 23, 2009 at 07:42 PM

Query Exceptions

31 Views

Hello

I need to create a report with exceptions for variance %

Red --> less than zero

Yellow --> 0 to -10

Green --> Greater than zero

While creating the exception for Red and Green, I dont know the upper limit or the lower limit, as they keep varying.

I cannot give a variable selection as the user do not know the limit value.

How can I define an exception to say greater than zero or less than zero ??

Please Help.

Rad