Filter with empty value and equality operator

1

Hi all,
I can’t understand why it is so difficult to apply a filter on numeric column with empty values, probably there is something I lost…

This is my first condition:

image
image871×307 20.6 KB

Then I tried with:
image

The only way I found is:
[EC1]=0 OR [EC1]=1 OR [EC1]=2 OR [EC1]=3 OR [EC1]=4 OR [EC1]=5

But it seems very strange to me it is the only way…

Could you please help me and clarify how to manage empty values in expressions with operators?

Thank you
Claudio

2

An empty value is not comparable to a number by design. This helps detect unexpected empty values. However, because of that, a filtering condition must do type-checking first. Here are examples of correct expressions for your case:

IF not isempty([EC1]) THEN [EC1] <= 5 ELSE false()

Alternatively

if( isempty([EC1]), false(), [EC1] <= 5)

If you only need to select a few integers, I would suggest using the simple “Filter” action.

3

I understand the reason and the solution, but it makes in complex conditions the formular more complex.

Maybe you can add it on the feature request list @dgudkov to have an option checkbox for the filters like "interpret empty values ​​as 0" and/or "interpret non numeric values ​​as 0".

hint for others - my workaround to keep the formular as simple as possible is a previous modify step, that sets non numeric values to 0. (but I would also be happy, if I can leave out this).

best wishes
Peter