QV - Error of basic formula (sum)

[stephane_kosior]

Hi,

There is something I don't understand. Please have a look of the file attached and you will see that the sum of a Table is different of the same table but with an additional dimension (JSNO - Journal)!!

Any idea why ?

Thank you

[Vegar]

My guess is that you are presenting your totals as sum of rows and not expression total and that some transactions are linked to more than one JSNO - Journal dimension value. 

[Vegar]

Consider this script:

Colors:
Load * inline [
Fruit, Color
Apple, Red
Apple, Green
Apple, Yellow
Banana, Yellow
Strawberry, Red]
;

Transactions:
Load
Fruit,
Quantity

inline [
Fruit, Quantity
Apple, 100
Strawberry, 200
Banana, 300]
;

It will result in these two tables (upper part of picture). Below I've added a table using sum Quantity with the two different total sum methods. Do you see and understand the difference?

re

[stephane_kosior]

Unfortunatly this is not the problem because this is not a problem of doing the sum of the column ... but the sum itself. I mean there are two lines and by doing the sum in a text box should give me the right value (7658 instead of 3829 only)

[Vegar]

I don't really flow you? I don't see the figures 7658 and 3829 in the picture you provided.

Could you please try to explain the issue again with other words and/or picture?

[stephane_kosior]

Have found the solution by creating a concatenate field ... thank you guys