How to sum unique values?

Hey guys,

I have these two tables, wich i make a left join.
But this join gives me duplicate values of HOURS, i need to sum the QTD and divide by the unique value of hours, how can i make this?


It’s simple, add hours in group and sum of QTD calculation field in value. QS will group by 50,100 of hours.

Naveed Ali