Function expressions

Function expressions are global functions and are very practical when you have several KPIs that use the same function.

 

An example could be 10 schools that have a common KPI. Instead of maintaining 10 functions, create one expression that contains the function and use it for each school. Maintenance is simplified because changes in the expression formula are reflected in all KPIs that use it.

 

Function expressions are created in Expressions in the View menu, or under Structure in the Window menu. They are stored in Categories, so you must create at least one category before you can create a Function expression.

Creating Function expressions

To create a Function expression, right click a Category in the Expression panel and choose Add -> Expression -> Function expression.

Properties

General

Function

Click the icon to the right of the Function field to open the calculator.

Function expressions have no formatting of their own. The formatting of the function containing the expression will be used, and values in drills are displayed using the same formatting as the function containing the expression.

Audit

Advanced

ID

 

Access control

Using Function expressions

Function expressions are located in a separate tab in the Function calculator. To use an existing Function expression in a calculation, click the Expressions tab in the Calculator and double-click the desired expression. Corporater BMP adds it in the Calculation field as {expression ID}.

Alternatively, enter the Function expression's ID directly into the Calculation field.

 

Function expressions can be created directly in the Expression tab in the Calculator. Right click in the Expression tab and choose Function expression in the menu. Then right click the new Function expression, choose Edit, and configure it as described above.

Previewing Function expressions

To preview the result of a Function expression based on its current configuration, select it from the Business Management Platform model,

select the Preview tab, and then click the Refresh button ().

The Result subtab displays result values and their applicable range for each function in the expression.

To view a report on the calculations behind the expression, select the Profile tab.

 

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.