Comparison Functions

  • Updated

Return values based on logical operations.

Comparison Function

Description

AllAreFalse

The AllAreFalse function returns true if all of the provided conditions is false. Otherwise false.

AllAreTrue

Returns true if all of the provided conditions are true. Otherwise false.

AnyAreFalse

The AnyAreFalse function returns true if any of the provided conditions is false. Otherwise false.

AnyAreTrue

Returns true if any of the provided conditions are true. Otherwise false.

EqualTo

Returns true if two expressions are equal.

GreaterThan

Returns true if the first expression is greater than the second expression.

GreaterThanOrEqual

Returns true if the first expression is greater than or equal to the second expression.

If

The If function returns one of two values, depending on a given condition.

IfCase

The IfCase function compares a test value against a list of values, returning the result from the first matching pair.

IfChain

The IfChain function returns the return value from the first true condition in a list.

Instr

The Instr function returns the position of the first occurrence of one string within another string.

IsBetween

Returns true if a value is equal to or between two boundary values.

IsClassification

Returns true the given field meets the criteria to belong to the given classification.

IsMatch

Determines if a given value is found in a list of values.

IsNotNullOrEmpty

The IsNotNullOrEmpty function returns true if a field is not null or empty.

IsNull

The IsNull function returns true if a field is null.

IsNullOrEmpty

The IsNullOrEmpty function returns true if a field is null or empty.

IsNumeric

Returns true if a value is or can be converted to a number without error.

Largest

Returns the largest value in a list of values.

LessThan

Returns true if the first expression is less than the second expression.

LessThanOrEqual

Returns true if the first expression is less than or equal to the second expression.

NoneAreFalse

The NoneAreFalse function returns true if none of the provided conditions is false. Otherwise false.

NoneAreTrue

The NoneAreTrue function returns true if none of the provided conditions is true. Otherwise false.

NotEqualTo

Return true if two expressions are not equal.

NotEqualTo

Return true if two expressions are not equal.

NumberOfFalse

The NumberOfFalse function returns the number of provided conditions that evaluate as false.

NumberOfTrue

The NumberOfTrue function returns the number of provided conditions that evaluate as true.

NumFracDigits

Returns the number of digits in a given number that appear to the right of the decimal point, not counting trailing zeros.

NumIntDigits

Returns the number of digits in a given number that appear to the left of the decimal point, not counting preceding zeros.

Smallest

Returns the smallest value from a list of values.



Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.