Hi everyone,
I was doing Lesson 5 Challenge in the Developer course that has an if() function and the condition to be tested is isnull(ri!test). So my expression looks like this:
if( isnull(ri!test), "null", ri!test)
Now my issue is, whether the input I put in is 0 or not, it always returns the ri!test.
I tested the isnull() separately, and it doesn't return True if the value i pass is 0. Can someone help if I'm doing something wrong here?
All I can think of is that 0 is not being read as a null input.
when I specifically type in isnull(null) , it returns True. But when I type in isnull(0) and test, it gives a False.
Discussion posts and replies are publicly visible
isnull() check only if ri!test contains a value or not if we are not passing any value to ri!test then isnull(ri!test) returns true but if we pass 0 then isnull(ri!test) considers that ri!test has a value and returns false
"0" is an integer value, so by definition, not null. Thus there is no expectation that it should return true when passed into isnull(). The only things that you'd expect to test as null are blank values ("") and completely empty lists.
Thank you