Alerters and undefined variables??

[emcevoy]

Hi,

I am wondering if anyone out there has come up with this issue.

I have variable that calculates a number. I have formated the cell to show 0 if undefined.

then in my alerter I have

>= <mynumber> then green
< <mynumber> then red
= <mynumber> then yellow

My issue is that the alerter does not know when undefined and I am looking for anyone with some options.

Thanks a bunch


Eileen McEvoy
Authorized Crystal Engineer
Crystal Reports Consultant and Trainer

http://www.crystalconsulting.ca

emcevoy@crystalconsulting.ca

 

[Sridharan]

Hi,

Suppose you variable is called <Sales>.

Create a variable as IsNull(<Sales>) which will return 1 or 0. Use that in the Alerter to change the display.

Sri