The following mathematical functions have been provided:
- Avg
- Count
- Max
- Min
- Round
- Summation
Avg
Average determines the average value of all arguments and returns this one. The function NodeValues can also be used as argument.
Syntax | Return value |
avg(arg[1],.. arg[n]) | Double |
Example |
|
Expression: | Result: |
avg(1,2,3,4,5) | 3 |
Count
Count returns the number of all arguments (indicating how many arguments there are). The functions NodeValues and Nodes can also be used as arguments.
Syntax | Return value |
count(arg[1],.. arg[n]) | Integer |
Example |
|
Expression: | Result: |
count(1,1,2,2) | 4 |
count(nodes("/purchaseOrder/item/quantity")) | 3 |
Max
Max returns the maximum of all arguments. The function NodeValues can also be used as argument.
Syntax | Return value |
max(arg[1],.. arg[n]) | Double |
Example |
|
Expression: | Result: |
max(1,2,3,4,5) | 5 |
max(nodeValues("/purchaseOrder/item/quantity")) | 100 |
Min
Min returns the minimum of all arguments. The function NodeValues can also be used as argument.
Syntax | Return value |
min(arg[1],.. arg[n]) | Double |
Example |
|
Expression: | Result: |
min(1,2,3,4,5) | 1 |
min(nodeValues("/purchaseOrder/item/quantity")) | 0.0 |
Round
The Round function rounds the argument, after the right-of-comma position Up or Down, indicated in the second argument, are rounded. (Values < 5 are rounded down and Values >= 5 are rounded up!)
Summation
Summation determines the total value of all arguments, and returns this one. The function NodeValues can also be used as an argument.
Syntax | Return value |
sum(arg[1], .. arg[n]) | Double |
Example |
|
Expression: | Result: |
sum(2,3,4,5) | 14.0 |
sum(nodeValues("/purchaseOrder/item/quantity"))= | 102.0 |