Grand Total Mismatch Issue in OAS

Question

Hello everyone,

I'm having trouble understanding why my grand total is showing the wrong number when I sum the values in my rows.

The column named "SIT. PC CALC" shows descriptions based on my sales — specifically, whether they are pending ("PENDENTE" in Portuguese) or not pending. The "QTD. PC" column represents the quantity.

If I sum the "QTD. PC" values for the "PENDING" category, the result should be 29,241. However, my total is showing 24,826 instead.

The "QTD. PC" is a calculated column created using COUNT DISTINCT on a column containing sale numbers.

Why is this discrepancy happening?

Thank you all so much.

Gianni Ceresa · Answer

Hi,

You have the answer available: look at the generated query. The product doesn't invent any number, it does run queries. Queries are generated based on models. If you look at the generated query for your analysis, you will see how that 24,826 is calculated. And by looking at that query, you will probably see what is happening in a different way than what you expected (to get your 29,241). The logs have the answer, because it depends on your model.