Function syntax

In order for a Function element to be calculated, the expression in the function field must contain at least one of the following:

Numeric value
Node - If the function contains a node it must also contain the following information:
- Organization - if nothing is specified, the current organization is used.
- Node type - if nothing is specified Node type is set to correspond to the function type.
- Time period - if nothing is specified BOP,EOP (beginning of period, end of period), or BOY,EOY (beginning of year, end of year) when using YTD (year to date), are implicit.
Expression
Tag

Functions can be divided into two main groups: Ordinary and Time. Time functions are used to control the time period when data is extracted. They are constructed using Start and End with time adjustments to set the date range for the extraction interval.

Syntax rules

It is important that the function syntax is correct. Incorrect syntax can lead to incorrect values. The following rules apply:

Only Node IDs are used, not node names. They must be enclosed in square brackets [120]

If the node has subnodes their values will also be included (aggregated).

Time period specification for a node must also be inside the brackets. [120,bop,eop]
In functions that use both nodes and organization parameters, the node expression must always be inside apostrophes, e.g. '[100]+[120]', and the node and organization expression must be inside parentheses, e.g. AGG('[100]+[120]',org1,org2)

Syntax of an AGG function:

AGG('[node1, start function+adjusting function, end function+adjusting function] + [node2, start function+adjusting function, end function+adjusting function]',org1,org2)

Use the Function calculator to help define functions.

Both upper and lower case letters may be used in functions.