Summing independently from GroupHeaderBands

[SumRunning]

Hello,

summing independently from GroupHeaders.jpg (25.44 KiB) Viewed 4779 times

Within a month, employees work different hours on various projects. Each project is assigned a cost center called "Cost WBS". The goal of the report is to determine the total costs of all employees per cost center. The costs per employee AND per cost center must be calculated based on the percentage of the " total working hours (per employee) / working hours per WBS (per employee) ". How can I calculate the total working hours "total WorkHours" (purple text), given that the parent GroupHeaderBand prevents this because it is grouped by cost center WBS?

Designer_summing independently from GroupHeaders.jpg (53.88 KiB) Viewed 4779 times

Groupheader 4 is grouped by Cost WBS. --> ({WorkDay.TimeBookings.Equipment.CustomText07}&&{WorkDay.Employee.CustomText06})

Thanks in advance.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data for analysis.

Thank you.

[SumRunning]

Sorry for my late response. I am attaching a sample report and test data.

The test data shows 2 employees.

Screenshot 2024-08-22 103926.png (26.82 KiB) Viewed 4076 times

One has a PayRollItem of 500 per month and the other one has one of 350 per month. In this test example we have 3 different "Cost WBS" and a blank one. The goal of the report is now to summarize the "Costs per WBS" (yellow) for each "Cost WBS". So for example the result for the Cost WBS "C-85-832147-081-0109-133" should be 250 + 222.7272 = 472.7272

Thanks for your help and kind regards,
Tobias

PS: Sorry I had to convert the .xml - TestData to .zip to be able to upload it.

[Lech Kulikowski]

Hello,

The sent data and data structure in your report are different, it is difficult to analyze something.

Thank you.

[SumRunning]

Does this .xlsx file work?
If not please let me know what`s your preferred data type.

Thank you.

[Lech Kulikowski]

Hello,

The same result.
We need a report or sample that we can run and see your data structure, test data and your report.

Thank you.