syntax:operators
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
syntax:operators [2016/06/08 21:11] – dmitry | syntax:operators [2020/11/26 18:27] – dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
Here is list of operators that can be used in expressions in EasyMorph. | Here is list of operators that can be used in expressions in EasyMorph. | ||
+ | |||
+ | === Basic operators === | ||
^ Operator | ^ Operator | ||
Line 30: | Line 32: | ||
| | ||
([Amount] > 1000 and [Quantity] > 1) or [Quantity]> | ([Amount] > 1000 and [Quantity] > 1) or [Quantity]> | ||
+ | | ||
+ | === The IF..THEN..ELSE operator === | ||
+ | This operator can be used to perform conditional calculations. It has the following syntax: | ||
+ | |||
+ | IF // | ||
+ | |||
+ | A shorter form where the ELSE expression is omitted and always returns an empty value, is also possible: | ||
+ | |||
+ | IF // | ||
+ | |||
+ | Note that unlike the [[syntax: | ||
+ | |||
+ | Examples: | ||
+ | |||
+ | IF [Amount] > 1000 THEN 'Large order' ELSE 'Small order' | ||
+ | |||
+ | IF [Year] = year(today()) THEN [Amount] ELSE 0 | ||
+ | |||
+ | IF [Qty] = 0 THEN 0 ELSE [Amount] / [Qty] // Doesn' | ||
+ | | ||
+ | === 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: | ||
+ | |||
+ | LET // | ||
+ | |||
+ | Once a local constant is declared, it can be used in the expression(s) that follow the declaration. Example: | ||
+ | |||
+ | LET d = day(today()) | ||
+ | IF d=1 THEN 'First day' ELSE 'Day: ' & d |
syntax/operators.txt · Last modified: 2021/01/13 18:43 by dmitry