Skip to Content
Jan 02, 2018 at 05:59 PM

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?