Skip to Content

duplicate values in running totals

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 02, 2018 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.



    Add comment
    10|10000 characters needed characters exceeded