Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why Sum(backlog_accessories_quantity) is 4 not 2?
because in your model, the table containing the "backlog_accessories_quantity" field is associated to another table.
This association might cause a duplication in your lines.
Let me try to explain it simpler with an example:
Table 1:
| ID | SALES |
| 1 | 2 |
Table 2:
| ID | DATE |
| 1 | DATE1 |
| 1 | DATE2 |
When you have a model like this, if you create sum(Sales) for ID=1 it will be 4 instead of 2 because the ID=1 exists in the table 2 in 2 different lines..
Hope this was clear?
Because you probably have two records in the data where backlog_accessories_quantity is 2.
Test and see what Count(backlog_accessories_quantity) evaluates to.
yes,thank you