IsNull Error

[#1]

Hi, i was wondering if someone could give me a hand with this. Why do i keep getting error in expression? Thank you!

[sunny_talwar]

May be try this:

Max({<ba_userid = {'*'}>} Fecha)

[Nicole-Smith]

As an explanation, you can't use a calculation on the left side of a set analysis expression like you currently have.  The left side needs to be a field that exists within your data.  The right side can be a calculation though.  Editing your set analysis to use the same expression on the right side instead of the left would yield this:

Max({<ba_userid = {'=IsNull(ba_userid)=0'}>} Fecha)

[Chanty4u]

try below

=Max({<ba_userid ={0],ba_userid ={''}>}Fecha)

[engishfaque]

Hi Elina,

Here is the expressions for null value,

1. Retrieve Max Fecha where ba_userid is equal to Null

=Max({<ba_userid = {'=Null()'}>} Fecha)

2. Retrieve Max Fecha where ba_userid is not equal to Null

=Max({<ba_userid -= {'=Null()'}>} Fecha)

Kind regards,

Ishfaque Ahmed

[sdmech81]

Try this aswell:

1. Retrieve Max Fecha where ba_userid is equal to Null

=Max({<len(ba_userid)=0>} Fecha)

2. Retrieve Max Fecha where ba_userid is not equal to Null

=Max({<len(ba_userid)-=0>} Fecha)

Sachin

[vardhancse]

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).