on 01-02-2018 5:59 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
26 | |
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.