Expression

[yuech1]

Why Sum(backlog_accessories_quantity) is 4 not 2?

[OmarBenSalem]

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?

[hic]

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.

[yuech1]

yes,thank you

[Hoffman14]

The means of expression transform what is expressed, in the process of conveying it. From the Cambridge English Corpus. This awareness might have had two possible means of expression in the orthography  Costco Employee ESS