Alerters - Null Value

building reports desktopintelligence
1

I have reports that have several alerters regarding different metrics. However, if the value is “null” I’d like the alerter to be blank. When I put =Null into the Alerter, it blanks everything out.

Any ideas? All help is appreciated.

Thanks!
Tracey

TWaits (BOB member since 2005-12-20)

2

You can create a variable using ISNULL function and use then in Alerters in combinition with your other criteria.

mkumar (BOB member since 2002-08-26)

3

You’ve certainly peaked my interest - can I get a little more detail on how to do that? Thanks!

TWaits (BOB member since 2005-12-20)

4

Create a variable with following formula

=If IsNull(<Obj>) Then 1 Else 0

and apply an Alert on this new variable having values of 1/0 instead of Null

mkumar (BOB member since 2002-08-26)

5

That sounds like it would work - however, I have alerters already on the current object that are green or red, depending on the value. Is there a way to add “Null” to the current alerter?

TWaits (BOB member since 2005-12-20)

6

With the current objetc if it is a local variable edit it to include null conditon or if it a universe object do condition something like this

=If isNull(<Object>) then 1 else if <Object> >=100 Then 2 Else If <Object><100 Then 3

Now in the alerters define green for 2 red for 3 and white background and white font for 1

KhoushikTTT :us: (BOB member since 2005-02-24)