kpy problem

[Carlaf_93]

Good afternoon,

i've got a problem with this dataset.

If i use the formula sum(VALUE/QUANTITY) i don't get the right sum of price...

What do i need to do?

This the wrong kpy --> it should be   1.113.041

[marcus_sommer]

Try it with: sum(aggr(sum(VALUE/QUANTITY), customer, code))

- Marcus

[Carlaf_93]

I tryed this one:

SUM(AGGR(SUM(DISTINCT FLOOR(VALUE/QUANTITY,0.1)),KEY3))

where KEY3 IS customer & '_' & code in the script area.

This is the best one but not  the same as the sum....

I've got many data and doesn't work with all of them...

other ideas?

Thanks

[marcus_sommer · Accepted solution]

I assume these data aren't loaded within Qlik else exported from there. In this case there are any duplicates within the data which aren't displayed within this table because only distinct combinations of field-values are shown. You could check this by adding a recno() and rowno() to your load and including these fields within your table, too.

- Marcus

[MarcoWedel]

how did you calculate 1.113.041 ?