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 |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0b780bca-4556-4d13-b680-61867ea12179"><ac:plain-text-body><![CDATA[ |
avg(arg[1],.. arg[n]) |
Double |
]]></ac:plain-text-body></ac:structured-macro> |
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 |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="68d047e1-f971-477d-aa0f-d507ba33df2f"><ac:plain-text-body><![CDATA[ |
count(arg[1],.. arg[n]) |
Integer |
]]></ac:plain-text-body></ac:structured-macro> |
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 |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b65c05bc-73ec-473e-94d7-2057a82bded3"><ac:plain-text-body><![CDATA[ |
max(arg[1],.. arg[n]) |
Double |
]]></ac:plain-text-body></ac:structured-macro> |
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 |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="077cf650-708c-4c18-ad0e-de3f3edcc458"><ac:plain-text-body><![CDATA[ |
min(arg[1],.. arg[n]) |
Double |
]]></ac:plain-text-body></ac:structured-macro> |
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!)
Syntax |
Return value |
Double |
|
Example |
|
Expression: |
Result: |
round(1.2345,3) |
1.235 |
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 |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="223b266d-1b67-44b1-a4b8-e57ca6deff52"><ac:plain-text-body><![CDATA[ |
sum(arg[1], .. arg[n]) |
Double |
]]></ac:plain-text-body></ac:structured-macro> |
Example |
|
||
Expression: |
Result: |
||
sum(2,3,4,5) |
14.0 |
||
sum(nodeValues("/purchaseOrder/item/quantity"))= |
102.0 |