Built-in Functions → and

and() is a boolean function that returns true if the result of an AND operation on all of its arguments returns true, otherwise, it returns false.

Signature

Copy
and(bool exp,bool exp, ...)

• exp : a series of 2 or more bool expressions

Returns

bool

Example

This example returns true if AMOUNT_SOLD IS 3696.48, COST_OF_GOODS is 1670.79 and COUNTRY_NAME is "Argentina"

Copy
and(SALES.SALES.AMOUNT_SOLD=3696.48, SALES.SALES.COST_OF_GOODS=1670.79, SALES.COUNTRIES.COUNTRY_NAME="Argentina")