Logical functions

Logical functions

IF(<condition>,<true-expression>,<false-expression>)

Example
IF(1 == 2, "Condition is true", "Condition is false") returns "Condition is false".

NOT(<expression>)

Example  
NOT(true) returns false

COALESCE(…args)
Returns the first argument that is not null.

Example  
COALESCE(null,"a",2) returns "a".  

ISNULL(<check-expression>,<replacement-expression>)
If check-expression is null, returns replacement-expression, otherwise check-expression is returned.

Example
ISNULL(null,1) returns 1  ISNULL(10 \* 1, 100) returns 10

ISNULL(<check-expression>)
If check-expression is null, returns true, otherwise false

Example
ISNULL(null) returns true                                                                                          

ISNULLORZERO(<check-expression>,<replacement-expression>)
If check-expression is null or 0, returns replacement-expression, otherwise check-expression is returned.

ISNULLORZERO(<check_expression>)
If check-expression is NULL or 0, returns true, otherwise false.

Example
ISNULLORZERO(null) returns true

ISNUMBER(value) Checks if the data type of value is a number data type

Example
ISNUMBER(1) returns true
ISNUMBER("2") returns false

ISNUMERIC(value)
Checks whether value is a number or can be converted to a number

Example
ISNUMERIC(1) returns true  ISNUMERIC("2") returns true  
ISNUMERIC("a") returns false

ISERROR(<expression>)
Returns true if evaluation of expression results in an error

IFERROR(<check-expression>,<replacement-expression>)
If check-expression results in an error, returns replacement-expression, otherwise check-expression is returned.

ISNULLOREMPTYSTR(<expression>) | IsNullOrEmptyStr(<expression>)
Returns true if expression is null or an empty string

Example
ISNULLOREMPTYSTR(null) returns true  ISNULLOREMPTYSTR(\@ProductID[AccountID == "A100" && MarketID == "NO-V"])

NZ(<check-expression>)
If the check-expression is null or an empty string, returns 0, otherwise the check-expression is returned.

Example  
NZ(null) returns 0  NZ(1) returns 1  NZ(" ") returns 0