Remove Duplicate from SUM

[DBAFrog]

I have a query that pulls the Local and School tax from a payroll check, ie: wage = 1000.00 , local = 2.50, School = 2.00
Now when I rollup the group totals I get SUM of Wage = 2000.00 and SUM of PayDeductions = 4.50.

The Taxes are calculated correctly, but I have doubled the Wages ~ because the tax is calculated on the wage twice.

How can I remove the duplicate wage entry to rollup my report?

The bad news is that the local and school identifiers are all unique to the locality, so I can't just pull them from the PayDeductions tbl.

TIA

------------------
Curious by Nature,
Linux by Design

 

[Turkbear]

Hi, Perhaps adding a grouping on Wage and summing the deductions on that group.

Do not know if the business need would then be met, but it will eliminate the doubling of the wage

 

[DBAFrog]

Thanks, I had done that. But I think I have the answer. The overlap of school dist. is causing a problem that I didn't see at first.


------------------
Curious by Nature,
Linux by Design

 

[lbass]

For the wage summary, you could use a running total that evaluates on change of payroll check (whatever field is unique to the check).

-LB