Formula that is evaluated when the value is read.
Namespace: Stemmer.Cvb.GevServer
Assembly: Stemmer.Cvb.GevServer (in Stemmer.Cvb.GevServer.dll) Version: 14.0.0.0
Syntax
Property Value
Type: StringString containing the formula.
Implements
ISwissKnifeNodeTNodeFormulaRemarks
Add the Variables before setting the formula as the formula's validity is checked on set.
The following operations are supported:
(, ) | brackets for grouping/overriding operator precedence: 3 * (2 + 3) results to 15. |
+, -, *, / | addition, subtraction, multiplication and devision: 3 * 7 + 4 / 2 results to 23. |
% | remainder: 7 % 4 results to 3. |
** | power: 2 ** 3 results to 8. |
&, |, ^, ~ | bitwise AND; OR, XOR and NOT: 2 | 1 results to 3. |
&&, || | logical AND and OR: 1 && 0 results to 0. |
<>, =, >, <, <=, >= | logical UNEQUAL, EQUAL, GREATER, LESS, LESS OR EQUAL and GREATER OR EQUAL: 3 >= 2 results to 1. |
<<, >> | shift left and shift right: 1 << 2 results to 4. |
? : | conditional operator <condition> ? <true case> : <false case>. |
SGN | Signum function: -1 if value smaller than 0; 0 if value equal to 0; 1 if value greater than 0: SGN(42) results to 1. |
NEG | Negative function: NEG(-42) results to 42. |
Keep in mind that a Floor(Double) operation is executed after each calculation. Logical operations result in 1 for and 0 for . Any number that is evaluated in a logical / condition is as long as it is not 0.
See Also