Example: Create Aggregate Calculations for Cumulative GPAs
This example illustrates how to use aggregate calculations to access cumulative grade point averages (GPAs) in student application contexts.
Alma Mater University (AMU) rates an undergraduate applicant's likelihood for admission based on the cumulative grade point average (GPA) and SAT total on their application. Workday uses the GPA and SAT total to calculate an applicant score that maps to the rating on an applicant score scale.
Workday stores the Cumulative GPA report field on the Student External Credential Assignment business object. To access cumulative GPA data in calculations for student applications, you need to create these aggregate calculations:
- Cumulative GPA - Student External Credential
- Cumulative GPA - Student External Transcript
Security:
- Access Calculation (Segmented)domain in the functional areas for Core Payroll, Implementation, Payroll Interface, and Time Off and Leave.
- Set Up: Calculations - Genericdomain in the Core Payroll functional area.
- Set Up: Time Off (Calculations - Generic)domain in the Time Off and Leave functional area.
- Access theCreate Aggregate Calculationtask.
- Enter or select these values:FieldValueNameCumulative GPA - Student External CredentialCategoryAdmissionsAcademic UnitAlma Mater UniversityFunctionMaximumOperandCredential Assignment Cumulative GPAInstance for Operand CalculationStudent External Credential
- ClickOKandDone.
- Access theCreate Aggregate Calculationtask.
- Enter or select these values:FieldValueNameCumulative GPA - Student External TranscriptCategoryAdmissionsAcademic UnitAlma Mater UniversityFunctionMaximumOperandCumulative GPA - Student External CredentialInstance for Operand CalculationStudent External Transcript
- ClickOKandDone.
Use the
Cumulative GPA - Student External Transcript
aggregate calculation in higher-level calculations for student applicant scores.