cancel
Showing results for 
Search instead for 
Did you mean: 

duplicate values in running totals

steverdan
Participant
0 Kudos

I have a report that is generating info based on multi-layer information What we have is a job, with sub jobs linked into it. I want to get the totals of the jobs in an area based on the total of the main job. When I do a total based on the top level, it is adding the value of the top level for each sub job. so if I have three subs, and the main job is 200, then the total I get is 600. If I do the totals based only on the jobs, then the totals doesn't include the sub jobs, again misleading info. How can I get the totals corrected?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member292966
Active Contributor
0 Kudos

Hi Steve,

You actually need 2 running totals here. The first is to sum the SubJobs and pass the sum up to a running total in your Job.

Your report should be structured to have a Group on Job then another Group below that on SubJob. In the SubJob Group Header, make you running total variables reinitialize to 0 so they don't carry to the next SubJob.

In the SubJob Group Footer, pass the subtotal to the Job variable.

Let me know if you need a more detailed explanation and example.

Thanks,

Brian