The following sample data shows a Leave/Return from Leave job history report for 4 employees. The first column identifies which rows are the GH- Group Header and D-Detail. The data is grouped on ({PS_JOB.EMPLID}). What I need to determine on the Group Header row, is how many times in 2006 the...
I need some help calculating the sum of a group maximum values.
This is what I have…
Group 1 - Group data by EMPLID
Group 2 - Group by Company Code
For each company, the employee has accumulated monthly earnings. So to get the maximum earnings per company I do step 3.
Step 3 - Insert...
I need some help calculating the sum of a group maximum values.
This is what I have…
Group 1 - Group data by EMPLID
Group 2 - Group by Company Code
For each company, the employee has accumulated monthly earnings. So to get the maximum earnings per company I do step 3.
Step 3 - Insert...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.