Calculation Incorrect

[fsupport1600]

I am trying to calculate the total number a product is selected based on the following table fields:

prodTagId
Quantity

I created the following query:

prodTagID sumQty: Quantity
tblFunitureSelection tblFunitureSelection
Group By Sum
Ascending Ascending

The the sumQty results equals "16" even though the Quantity is set to 1. This is for a single product too. I am not sure where it is getting the "16" value from. If I set the Quantity to 2, the sumQty value = "32".

 

[fsupport1600]

Recreated it using the query wizard and the totals are calculating correctly now. Very odd. I notice the new query did not have any sorting options selected, so not sure if that was causing the issue or not.