I have a rule that checks if a field value is in some boundaries. If it is in the boundaries, it has to return empty(), if the value is empty, it must also return empty().
I noticed that when I add the rule like below, when DOSSIER_NUMMER is an empty value, it does not return the empty value as set in the rule. When I separate that in 2 conditions, first checking if it is empty and then checking the boundary conditions, it is working. Why does it fail in the first option ?
I should expect that the rule also returns to true?
See the example file in attachement.
([DOSSIER_NUMMER] >= 4000000000 and [DOSSIER_NUMMER] <= 4000999999)
or ([DOSSIER_NUMMER] >= 8000000000 and [DOSSIER_NUMMER] <= 8000999999)
or ([DOSSIER_NUMMER] >= 780000000 and [DOSSIER_NUMMER] <= 7800009999)
example.morph (2.7 KB)