Syntax for Calculated Fields
|
Description |
Syntax |
|---|---|
Adding | + |
Subtracting | - |
Multiplying | * |
Dividing | / |
If-then-else | (condition) ? (value if true) : (value if not true) |
Equality check | == |
Not equal check | != |
Greater than | > |
Less than | < |
Greater than or equal to | >= |
Less than or equal to | <= |
And (joining 2 conditions) | && |
OR (joining 2 conditions) | || |