topic Re: Expression in App Development

Expression

yuech1 — Thu, 07 Jul 2022 07:20:38 GMT

Why Sum(backlog_accessories_quantity) is 4 not 2?

Re: Expression

OmarBenSalem — Thu, 07 Jul 2022 08:04:48 GMT

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?

Re: Expression

hic — Thu, 07 Jul 2022 08:05:44 GMT

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.

Re: Expression

yuech1 — Fri, 08 Jul 2022 05:38:22 GMT

yes,thank you