Grand Totals wrong on PO report

 Hello

I am updating a custom PO report template, trying to display a grand total for piece count (I never worked in BI Pub before).  Each line quantity is displaying the field "Quantity".   For the total I am using "Quantity Ordered" field with SUM selected.  This works fine until a line is cancelled.  The line shows zero ordered but the total does not decrease.  I figured this is because I am using the qty ordered field.  If I use the "Quantity" field with SUM selected for the total quantity calculation, my totals are double the amount they should be.  Any help