sum() shows amounts twice as much as in source

[#1]

hi community,

i encountered a strange problem, and cant find an explanation of what went wrong.

the goal was to compare data of 3 different systems.

some (few) records show amounts twice as much as they are, when i use sum()

sum({<[SOURCE]={'sys3'}>}Amount)

even if i dont load the tables for sys 1 and 2, the data of sys3 is displayed twice as much as in the source table.

but this happens only to a few records.

and it doesnt matter, if the source table is XLS or CSV.

do you have any suggestions / assumtions ?

[swuehl]

Alexander,

please double check that you don't have double records for those Buch_Ids you want to group by your Amount.

The table box won't show double records.

Do you have a unique record ID? Add this field to your table box  as field and to your chart as expression ( =count(UniqueID) )

[hallquist_nate]

Add the script RowNo() to your load script and alias it as Row Number, or something.  Maybe you have multiple entries for Buch_ID and don't know and it is causing a foul-up with your summing.  Add the Row Number to your table and look for the specific Buch_ID's that you are having and issue with and see if you have multiple entries.

Good luck.

[#4]

thanks for your suggestion swuehl,

- ID / Buch_ID is a unique ID for the record, and is used to compare the data on each system.

- there are no double records in the source tables, but maybe there are some created in the load script

- even if count(ID) shows '1', the problem persists.

[swuehl]

Could you post a small sample file?