aggregation question

[ngosz4074]

Hello,

I have two tables joined by Employee ID where I have the repeating total in one column and the correct hours value in the last (tbl2) column.  I have been using this Aggr(Sum([Measure -tbl1])),ID,Name,Code,Date) - but I get the same result. 

I added Distinct to the AGGR formula and I get 0,0,2,0 as a result set. 

Aggr(Sum(Distinct([Measure -tbl1])),ID,Name,Code,Date))

Any advice on tweaking the formula? 

ID	Name	Code	Measure -tbl1	Measure -tbl2
5	Joy	1550	30	10
5	Joy	1550	30	10
5	Joy	1550	30	9.75
5	Joy	1550	30	.25

Thanks in advance

Neal

[sunny_talwar]

What are you looking to get here?

[ngosz4074]

I'm hoping to get the same hours in the tbl1 column to tbl2 so we can compare hours between the tables.  I think we have different granularity levels, so that's why I was trying to work with AGGR.