HCM Extract

Summary

to output summation of leaves in Extract

Content

Is there a way in extract level or template level to have an output of summation of all leaves?

For example, Employee A has the following leaves

 

1^st Vacation leave  - 2days

2^nd Vacation leave – 3 days

3^rd Vacation leave – 1 day

 

1^st Sick leave – 5 days

2^nd Sick leave – 2 days

3^rd Sick Leave – 1 day

4^th Sick leave – 4 days

The output in Extract will be

Total number of leaves = Sum of all Sick leaves + Sum of all Vacation leaves +etc..

Name;Country;Phonenumber;Email;TotalLeave

EmployeeA;Netherland;89898998;EmployeeA@oracle.com;18days