Sie zeigen eine alte Version dieser Seite an. Zeigen Sie die aktuelle Version an.

Unterschiede anzeigen Seitenhistorie anzeigen

Version 1 Nächste Version anzeigen »

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="e45b27cb-7057-4701-a989-4eb8fb413fd4"><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="ac0fb016-36f6-4928-8d3c-5373ffeb5eac"><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="70a60b79-e831-46ea-81a3-8b55a84e3eb2"><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="e2af1469-84ed-407c-ac01-e290a5c5c729"><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

round(arg, decimal places )

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="3a77eb69-24f6-4e19-988e-81ca2dd5a347"><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

  • Keine Stichwörter