syntax:operators
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
syntax:operators [2021/01/13 18:43] – dmitry | syntax:operators [2025/06/18 21:59] (current) – dmitry | ||
---|---|---|---|
Line 3: | Line 3: | ||
Here is a list of operators that can be used in expressions in EasyMorph. | Here is a list of operators that can be used in expressions in EasyMorph. | ||
- | === Basic operators === | + | ==== Basic operators |
^ Operator | ^ Operator | ||
Line 33: | Line 33: | ||
([Amount] > 1000 and [Quantity] > 1) or [Quantity]> | ([Amount] > 1000 and [Quantity] > 1) or [Quantity]> | ||
| | ||
- | === The IF..THEN..ELSE operator === | + | ==== The IF..THEN..ELSE operator |
This operator can be used to perform conditional calculations. It has the following syntax: | This operator can be used to perform conditional calculations. It has the following syntax: | ||
Line 52: | Line 52: | ||
IF [Qty] = 0 THEN 0 ELSE [Amount] / [Qty] // Doesn' | IF [Qty] = 0 THEN 0 ELSE [Amount] / [Qty] // Doesn' | ||
| | ||
- | === The LET operator === | + | ==== The LET operator |
The LET operator allows simplifying expressions by declaring repetitive parts as local constants which can later be used instead of the repetitive parts. The operator has the following syntax: | The LET operator allows simplifying expressions by declaring repetitive parts as local constants which can later be used instead of the repetitive parts. The operator has the following syntax: | ||
Line 62: | Line 62: | ||
IF d=1 THEN 'First day' ELSE 'Day: ' & d | IF d=1 THEN 'First day' ELSE 'Day: ' & d | ||
- | === The ASSUME operator === | + | ==== The ASSUME operator |
The operator allows creating guarding conditions that must evaluate to TRUE before the expression is evaluated. ASSUME can be used to ensure data quality and integrity right in expressions. The operator has the following syntax: | The operator allows creating guarding conditions that must evaluate to TRUE before the expression is evaluated. ASSUME can be used to ensure data quality and integrity right in expressions. The operator has the following syntax: | ||
syntax/operators.txt · Last modified: 2025/06/18 21:59 by dmitry