Multiple Functions

A multiple function can process several KPIs at a time.

Multiple functions syntax

The multiple functions have two syntaxes:

1. М<Function>(Nested()).

The Nested() passes the values of nested KPIs to the function. Nested KPIs are the KPIs that are located one level below the edited KPI in the KPI tree.

For example, the Revenue KPI depends on the Revenue (Products) KPI and Revenue (Services) KPI (fig. 1). In this case, to get the Revenue KPI value, you need to use the МSum(Nested()) function.

Fig. 1. Revenue KPI and its nested metrics

This syntax is convenient because if the list of nested KPIs changes and/or the nested KPIs are changed, the formula remains the same.

2. М<Function>(new[]{<KPI 1>, < KPI 2>,...,< KPI N>}).

This syntax in convenient for cases when calculating the value of the edited KPI requires you to use KPIs that are not nested, and when calculating the KPI value requires you to use not all of its nested KPIs. For example, the value of the Revenue KPI depends on the total amount of the Revenue, Office 1 and Revenue, Office 2 KPI, that are not nested (fig. 2). In this case, to obtain the Revenue KPI value, use the МSum(new[]{"Revenue, Office 1 ", " Revenue, Office 3 "}) function.

Fig. 2. KPIs