Skip to Content

duplicate values in running totals

Jan 02 at 05:59 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Jan 02 at 06:32 PM

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.



10 |10000 characters needed characters left characters exceeded