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 11: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