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
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"
and(SALES.SALES.AMOUNT_SOLD=3696.48, SALES.SALES.COST_OF_GOODS=1670.79, SALES.COUNTRIES.COUNTRY_NAME="Argentina")