sum function results are wrong

[#1]

Hi, I did a pivot table in excel:

Store	PO_num	Sum of linecost
A	1234	56456
B	1234	34573
C	1234	35747
Total		126776

But when I did a straight table version of the excel pivot table in qlikview, the numbers do not tally.

I tried using the formulas 'sum(linecost)' and 'aggr(sum(linecost),PO_num,Store)' but it does not work.

Thanks.

[Gysbert_Wassenaar]

It's impossible to tell from your description what the cause is. Can you post a document that demonstrates the problem?

[simondachstr]

All row-sums do not tally or just the totals?

[#4]

When I just do a table box plainly displaying the Store,PO_num and the respective linecosts, the values are correct, but when I put the dimensions Store,PO_num and the expression 'aggr(sum(linecost),PO_num)' in a straight table, the sums are accumulated and displayed for only 1 Store (See below):

Store	PO_num	aggr(sum(linecost),PO_num)
A	1234	-
B	1234	126776
C	1234	-

[PrashantSangle]

Hi,

You dont need to use Aggr()

just write lineCost in expression

Or you can try like

Aggr(sum(linecost),store,PO_num)

Regards

[#6]

Hi, I've tried 'Aggr(sum(linecost),store,PO_num)' but the sums are wrong:

Store	PO_num	Sum of linecost
A	1234	56456
B	1234	34573
C	1234	35747

[PrashantSangle]

Hi,

Can you share your apps?

Regards,

[simondachstr]

This looks like a data model issue. Try putting sum(linecost) in a textbox and cross check with your Excel sheet.