AND argument limit of 2

[CloudMonkey]

Hi,

I'm trying to create a calculated field and I see there is a limit on the number of arguments of 2. Please does anyone know how to build an AND query with 5 arguments?

Thanks,

CM

[OwenAuger · Accepted solution]

Hi CloudMonkey

You can use the double ampersand operator (&&) to form the conjunction of more than two expressions.
e.g. A && B && C &&...

Or you could nest a bunch of AND functions, but that's probably harder to read.

[CloudMonkey]

Brilliant, thanks!