Cannot summarize or add a shared number to a graph

[panosSivTS]

Hello all,

I have a problem with a shared number from a subreport (empl_work_hours)

Cannot be summarized so we have create a shared number var "total" which is increased by adding the value every time to have this

The problem is that we need this value to put it in a graph

Is there a way or a different way to do that?

You can find the report attached

Thank you

 

[panosSivTS]

I am trying to setup all to table to one report but i have wrong summaries

For example i need to have the summary of actual hours of an employee but when i include the employee_day table which has 365 lines of the specific employee (line per day) the result is x365

I have include the report to check what i mean. As you can see we have a total summary 320 thousand hours instead of 5 thousand for hours worked which is the normal value

 

[panosSivTS]

I have finally have the results without subreports with running totals

But it is not possible to have this values as a percentance or insert the "percent" formula in the chart

You think that is there a way to have this result? Create familiar formulas instead of running total maybe? is that logic possible?