The following mathematical functions have been provided:
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="c62de57a-6257-4e0e-9747-e27e579cb955"><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="8673582f-4f7d-44ed-b8de-b68d29c02052"><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="9651296f-ae2e-4764-be68-3594ad575792"><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="f5a34856-35a0-466c-969d-2ddd022a75b8"><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="f7431abc-959f-495a-a09e-83ed56a1629b"><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 |