Forum Discussion
Difference between blank and empty in advanced filtering
Hi everyone,
I'm seeing a new dropdown option in the advanced filtering of dimensions.
What's the difference between "blank" and "empty"?
Kudo for your eagle eyes - this is a new setting in the service. BLANK is the equivalent of null, while "empty" is the equivalent of "" (an empty string).
7 Replies
Kudo for your eagle eyes - this is a new setting in the service. BLANK is the equivalent of null, while "empty" is the equivalent of "" (an empty string).
So,
If field is NULL or EMPTY STRING, then ISEMPTY = 1
If field is EMPTY STRING, then ISBLANK = 0, and ISEMPTY = 1
Would you agree?
interesting...
So even though the value in Column 1 is BLANK() the table itself is not EMPTY.
That means ISEMPTY() indicates that the filter column has no selectable values. My initial reply was incorrect.
Is this available in the desktop as well?
Edit. Updated to February build. It's in the desktop as well.Nice.
