IntSwissKnifeNodeFormula Property

CVB.Net Documentation
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

public string Formula { get; set; }

Property Value

Type: String
String containing the formula.

Implements

ISwissKnifeNodeTNodeFormula
Remarks

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>.
SGNSignum function: -1 if value smaller than 0; 0 if value equal to 0; 1 if value greater than 0: SGN(42) results to 1.
NEGNegative 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

Reference