Applying Not nUll

building reports webintelligence
1

Hi friends,

I want to create a variable in web intelligence. If you take one object like (Signed Date) So, I want to create a formulae like If (signed date) is notnull display 1 otherwise display 0

Regards,
Eswar

eswar519 (BOB member since 2009-05-26)

2 
if (not IsNull([variable]) ; 1; 0)

Dmitry Grekov :ru: (BOB member since 2009-09-29)

3

=If(Not( IsNull([Signed On])) And ([Signed On] < RelativeDate([Week End Date];14));1;0)

the above syntax is correct or not. Please tell me.

eswar519 (BOB member since 2009-05-26)

4

Should be correct

Dmitry Grekov :ru: (BOB member since 2009-09-29)

5

Thanks

eswar519 (BOB member since 2009-05-26)