i want to sum up all defective products in the production. To determine that an order is defective, the description "CANCELED" must be assigned to the order number. If an error exists, a 1 is stored for this cause of the error. Then 1 is to be multiplied by the number of pieces produced.
As far as i can see you are getting the 0´s in F_Axis column because the field MPS_productionorderitem.axisdefect is 0 for all MPS_productionorderitem.state = CANCELED. So if you multiply by 0 you will get 0 as result!