3sgrMath Data Types And Functions - 3sgr/DatacapOS GitHub Wiki

Data types

Integer
Float
Date
DateTime
String

Operations

"+" addition
"-" subtraction
"*" multiplication
"/" division
"<" less then (strictly)
">" more then(strictly)
"=<,<=" less or equeal
"=>,>=" more or equal
"<>" not equal

Keywords

Datacap

xPath
- Count(<xpath>) - returns number of nodes that match the "Select" Statement on the current Object node. Optionally, you can choose to search the entire batch.
- Sum(<xpath>) - returns sum of values according to xPath standard. Please search for more examples on how to use it.

Pure Math

sin(<value_or_function>)
cos(<value_or_function>)
abs(<value_or_function>)
exp(<value_or_function>)

Customization

Inside Custom Library you can create a delegate function with your own keyword name and implementation and add it to the list of "CustomFunctions" that is being passed to the formula processor. This gives you ability to extend this library with your own custom functionality still utilizing the formula processor. See / for more details.