How to sum unique values?

rribfilipe · April 25, 2022, 5:38pm

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?

Naveed · April 26, 2022, 5:26am

Hi,

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

regards,
Naveed Ali