fsupport1600
MIS
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".
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".