Operators

In AuditBoard Analytics expressions, operators can be used to build equations or compare values. Available operators are listed below:

Mathematical

Operator
Description

+ (plus)

Adds values

- (minus)

Subtracts values

* (asterisk)

Multiplies values

/ (slash)

Divides values

% (percent)

Calculates remainder of division calculation

^ (caret) OR ** (double asterisk)

Exponents

Comparison

Operator
Description

= OR ==

Equal to

!= OR <>

Not equal to

>

Greater than

<

Less than

>=

Greater than or equal to

<=

Less than or equal to

Logical

Description

AND

True if all conditions being checked are true

OR

True if any (or all) of the conditions being checked are true

NOT

Inverts the logic of a condition

Constants

Operator
Description

True

The boolean value True

False

The boolean value False

None

Null

Last updated

Was this helpful?