Difference between revisions of "Formula Specification in Templates"
Jump to navigation
Jump to search
Line 22: | Line 22: | ||
|TRUE | |TRUE | ||
|''TRUE()'' | |''TRUE()'' | ||
| | |Returns the logical value TRUE | ||
|''IF(TRUE();1;2) ⇒ 1'' | |''IF(TRUE();1;2) ⇒ 1'' | ||
|- | |- | ||
|FALSE | |FALSE | ||
|''FALSE()'' | |''FALSE()'' | ||
| | |Returns the logical value FALSE | ||
|''IF(FALSE();1;2) ⇒ 2'' | |''IF(FALSE();1;2) ⇒ 2'' | ||
|- | |- | ||
|IF | |IF | ||
|''IF(Test;Then;Else)'' | |''IF(Test;Then;Else)'' | ||
| | |Specifies a logical test to perform | ||
| | - inputs can be linked to data | ||
- result can be number, text, logical value | |||
|Result is number (bold inputs linked to data): | |||
IF(220>200;220-200;200-220) ''⇒ 20'' | |||
IF(MAX('''[Y_PDL⇕]''')>MAX('''[X_PDL⇕]''');+1;-1) | |||
Result is text: | |||
IF('''[Coordinate Z]'''>0;"Top above terrain";"Top under terrain") | |||
IF('''[GWT]'''<'''[Coordinate Z]''';"GWT under top of the test.";"Measure error.") | |||
|- | |- | ||
|IFS | |IFS | ||
|''IFS(Test1;Then1;Test2;Then2; ... ;Else)'' | |''IFS(Test1;Then1;Test2;Then2; ... ;Else)'' | ||
| | |Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition | ||
| | | | ||
|- | |- | ||
|NOT | |NOT | ||
|''NOT(Boolean)'' | |''NOT(Boolean)'' | ||
| | |Reverses the logic of its argument | ||
| | | | ||
|- | |- | ||
|SWITCH | |SWITCH | ||
|''SWITCH(Switch;Case1;Result1;Case2;Result2; ... ;[ Else ])'' | |''SWITCH(Switch;Case1;Result1;Case2;Result2; ... ;[ Else ])'' | ||
| | |Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned | ||
| | | | ||
|} | |} |
Revision as of 12:23, 20 March 2023
List of formula specification using in Templates.
Categories of functions:
Logical
Name | Syntax, parameters | Description | Example |
---|---|---|---|
AND | AND(Boolean1;Boolean2; ... ) | Returns TRUE if all of its arguments are TRUE | AND(3=3;2=2) ⇒ TRUE |
OR | OR(Boolean1;Boolean2; ... ) | Returns TRUE if any of its arguments are TRUE | OR(3=4;2=3) ⇒ FALSE |
TRUE | TRUE() | Returns the logical value TRUE | IF(TRUE();1;2) ⇒ 1 |
FALSE | FALSE() | Returns the logical value FALSE | IF(FALSE();1;2) ⇒ 2 |
IF | IF(Test;Then;Else) | Specifies a logical test to perform
- inputs can be linked to data - result can be number, text, logical value |
Result is number (bold inputs linked to data):
IF(220>200;220-200;200-220) ⇒ 20 IF(MAX([Y_PDL⇕])>MAX([X_PDL⇕]);+1;-1) Result is text: IF([Coordinate Z]>0;"Top above terrain";"Top under terrain") IF([GWT]<[Coordinate Z];"GWT under top of the test.";"Measure error.") |
IFS | IFS(Test1;Then1;Test2;Then2; ... ;Else) | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition | |
NOT | NOT(Boolean) | Reverses the logic of its argument | |
SWITCH | SWITCH(Switch;Case1;Result1;Case2;Result2; ... ;[ Else ]) | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned |
Mathematical
Name | Syntax, parameters | Description | Example |
---|---|---|---|
ABS | |||
ACOS | |||
ACOT | |||
ASIN | |||
ATAN | |||
COS | |||
SIN | |||
COT | |||
TAN | |||
EXP | |||
LN | |||
LOG | |||
LOG10 | |||
PI | |||
POWER | |||
SQR | |||
SQRT | |||
TAN |
vvv
Text
Name | Syntax, parameters | Description | Example |
---|---|---|---|
CONCAT |
vvv
Statistical
Name | Syntax, parameters | Description | Example |
---|---|---|---|
AVERAGE | |||
MAX | |||
MIN |
vvv
Matrix
Name | Syntax, parameters | Description | Example |
---|---|---|---|
LINEARTREND | |||
LINEARTRENDANDPOINTS | |||
LINEARTRENDSC | |||
LINEARTRENDSCANDPOINTS | |||
LINEARTRENDTOPOINTS | |||
SEMICIRCELTOPOINTS |
vvv