Forum Discussion
Error al sumar una columa
Hola, tengo una tabla con las ventas de una empresa, mi objetivo es saber la cantidad de unidades vendiadas por cada producto
El problema es que cuando quiero filtrar por un producto en especifico, no hace bien la suma
(He filtrado por el producto "195")
Y si ahora intento hacer una suma de cantidad, esto sucede.
Como se puede apreciar, los valores de cantidad han cambiado y el resultado final no es correcto.
Que puedo hacer?
Sorry for all this trouble, it was my fault, the ID column in some cases it was duplicated but it didnt shown in the report view.
2 Replies
- Icey
Community Support
Hi mreig ,
I create a simple sample. Is this the same as your scenario?
1. "Value" field (your "Cantidad" field) is a column and it's summarization is "Don't summarized".
2. When you keep the field as "Don't summarized",it works. But when you change it to "Sum", the total value is not correct.
If so, let's discussion one scenario.
In sample data, we can find that for Product "D", it has two values, "4" and "4".
When we keep "Value" field "Don't summarize", it only shows one row for Product "D".
This is by design. When two or more row have the same values completely, it will return the distinct rows content which every row value is the unique key in visuals.
Then if we change the summarization of "Value" field to "Sum". It will sum all the total value for Product "D" (4+4=8). So it will show as 8.
If this is not same as your scenario, please show me more details.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for all this trouble, it was my fault, the ID column in some cases it was duplicated but it didnt shown in the report view.
