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="4e37c877-f554-4474-a021-6bcff54f560d"><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="8aef25de-7d3c-465a-b8b8-135c9830516b"><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="66f0ca2d-e863-4e28-9108-2bfea7a08261"><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="618b4b99-0f63-4de6-9ac1-7b3f6fce5838"><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="4c4f3258-36aa-4289-89fb-6cf91d13506b"><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