Sum on graph not correct

[norbook_dev]

I have value in a QVD file e.g

cost	quantity	total
800	2	1600
1600	2	3200
3570	2	7140
4800	2	9600
4000	2	8000
5600	2	11200
		40740

However I am getting this when I use the sum function

cost	quantity	total
800	2	1600
1600	2	6400
3570	2	14,280
4800	2	24000
4000	2	19200
5600	2	11200
		177480

Apologies I am new to qlik

This is messing up my graphs

Here is the calculated field

sum(<[field1=,[field2]=, [field3]=[field4]-=[field5]=,[field6]=,[field7]=,[field8]=,[field9]=,[field10]=,[field11]=,[field12]=,[field13]=>}[Snapshot Quantity at Location]*[Snapshot Cost])

[Saravanan_Desingh]

I could not see any issue while summing. But, can you explain  me more on what you are trying?

[MayilVahanan]

Hi @norbook_dev 

Reason Might be, in ur data model, if you are doing any join with ur fact table, it cause the data duplicated.

Can you check, ur qvd record count is similar to ur data model table count. 

[norbook_dev]

Yea sum works ok when I have the table stand alone but when I add in sum it throws off sums

I think maybe Mayil Vahanan R may have a point about the fact table.  We are linking this up.