Knowledge Base Articles
Breadcrumbs

Showing calculated values of child items for their parents in Structure

This article is for Structure Data Center.

Problem

I want the Formula column to aggregate the calculated values of child items and show them for the parent items in my structure.

Solution

The numeric values can be aggregated from the bottom hierarchy levels to the top ones using the 'Sum over sub-items' option in the column's configuration: https://help.tempo.io/structure-dc/latest/totals-columns or by using the sum{} aggregate function: https://help.tempo.io/structure-dc/latest/aggregate-function-reference

For values of other formats, other aggregate functions can be used, depending on the details of your setup.