Hi,
How can i fix this error.
AND requires two or more yes/no expressions.
SELECT expressions return a list and not a yes/no value.
You may want to put ISNOTBLANK/ISBLANK around each SELECT expression, if that is what you want to evaluate.
1 Like
Almost everything in your expression is wrong. You should understand how individual expressions function and what values are returned by each expressions, so that you know what to expect by using one expression or another.
You need to spend sometime reading the documentation. You’ll save a lot of time and frustration reading first, rather than keeping running into problems and errors.
This is an easy read and also have a detailed video:
3 Likes