Rollups provide a quick and straightforward way to perform the following simple calculations:

CalculationDescription
Countcount the number
Sumcalculating the sum
Averagecalculating the average
Maximumdetermine the maximum
Minimumdetermine the minimum

🚧

Rollups will work for data connected via relationships only, and not for reference fields.

Rollup Calculations

The Rollup calculations are performed

  1. manually by clicking the Calculate Now button,
  2. every time the specified target field is modified, or
  3. a relationship is created or deleted.

Rollup Form

To create a new Rollup, open the UPMX Settings -> Rollups from the Application Menu and click the New button.

A – Create a short description of what the rollup is about.

B – Specify the type of calculation (Sum, Count, Average) for the rollup.

C – Uncheck this field to deactivate the rollup.

D – Specify the target table to which the rollup is performed.

E – Specify the target field of the target table to which the rollup is performed to.

F – This choice list allows you to specify the direction of the relationship by specifying if the target table is the parent, child, or both. The latter one will allow the rollup to consider any direction of the relationship.

G – You can select a single or multiple data sources from which the data will be rolled up.

H – Enter the name of the Source field name, e.g., opex_total. Please note that this field will not be visible when selecting the Count calculation type.

I – Leave this field empty to consider any relationship type, or specify here which relationship types should be considered.