Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i was wondering if someone could give me a hand with this. Why do i keep getting error in expression? Thank you!
May be try this:
Max({<ba_userid = {'*'}>} Fecha)
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)
try below
=Max({<ba_userid ={0],ba_userid ={''}>}Fecha)
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
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
The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).