Skip to main content
All CollectionsDynamic Formulas
Dynamic Formula Syntax
Dynamic Formula Syntax

Operators to use in dynamic formulas

Updated over a week ago

Element

Description

Example

+, -

Additive, Concatenation

100 + a

*, /, %

Multiplicative

100 * 2 / (3 % 2)

^

Power

2 ^ 16

-

Negation

-6 + 10

+

Concatenation

"abc" + "def"

==

Equal Comparison

if(Name == "Test")

=

Equal Assignment

var name = "Test"

<>

Not Equal

Name <> "Test", QTY <> 3

>, <

Greater Than, Less Than

QTY > 3

>=, <=

Greater Than or Equal To, Less Than or Equal To

QTY >= 3

&&, ||, !

Logical And, Or, and Not

(1 > 10) && (true || !false)

(statement? iftrue : iffalse)

Conditional (If statement)

(a > 100? "greater" : "less")

(type)variable

Cast

(int)100.25

[]

Array index

1 + arr[i+1]

.

Member

varA.varB.function("a")

String

literal

"string!"

Char

literal

'c'

Boolean

literal

true && false

Double and float

literal

100.25D + 100.25F

Integer

literal

100

\"

Syntax

Escape character for quotes, e.g. FirstMatch(Barcodes, "BARCOD_TYP == \"UPC\""

Did this answer your question?