Rollup Examples
Audience
Audience: Administrators
Overview
Administrators can create rollup formulas to perform calculations based on specific fields from the data source. Static Rollup Formulas include:
Split 
A SPLIT formula breaks a data string like comma delimited lists into substrings. 
Average 
Calculates the average a field (for example, average age). 
Count 
Counts a number of records that fit a given condition. 
Sum 
Total of all values in a specific field. 
Min 
The minimum value of a specific field. 
Max 
The maximum value of a specific field. 
For this example, we will build a static rollup formula to sum all the salaries of all employees..
Creating a Sum Formula

Log in to OrgChart.

Click on More > Chart Settings, and then select the Fields & Formulas option from the left side menu.

Click on the green f(x) Create button (in the top left corner) to create a new formula. The Static Formula Editor is displayed.

Click on the No values. Click here to add." hyperlink, and then select the Sum option from the dropdown menu.

Click on the Scope dropdown menu, and then select All Levels.

Check the Include Self checkbox.

Click on the Field dropdown menu, and then select the field that you want to sum (i.e Salary).

Click Save. The formula is added to the Fields and Formulas panel.

Mouse over a formula, and then click on the icon. The formula display options are displayed.

Click on the Field Type dropdown, and then select the Number option. This will ensure that the formula results display as a number.

Optionally, add a prefix, include an 1000 separator, and define the amount of decimals you would like displayed in the outcome.

Click Save and Refresh. When this formula is placed in a Box Style, the scope of the formula will determine what records beneath a record with the applied Box Style are included in the rollup.