Aggregated calculated columns can be used to aggregate or combine data into a single result or list. In this example, we will sum all Compensation records to get a Total Compensation result for each employee:
Create Aggregated Calculated Columns
Objective
After completing this lesson, you will be able to create aggregated calculated columns in SAP SuccessFactors Canvas Reports.
Aggregated Calculated Column Wizard
Value for Aggregation
In this example, we will aggregate all Compensation values, so we will set the column Amount from the Compensation object:
With Amount chosen as the column for aggregation, we now choose how to aggregate. Since we would like the total compensation per employee, we will choose Sum:
Aggregation Function
There are now two calculations in the query. Toggle the display of these columns in the query by choosing the red/green buttons:
