sum field after count distinct

[Anonymous]

Hello Qlikers!

Need help what  formula do I need for me to get the correct QTY  field.

correct QTY is derived by dividing QTY over # of LOTS per LOT TITLE.

I have done  sum(QTY) / # of LOTS but the result is 10639

or sum(QTY) / count(DISTINCT LOTS) = 23222.6

What I am after is the total of the correct QTY which is 168,649

LOTS	# of LOTS	QTY	correct QTY
LOT 1	2	26,098	13,049
LOT 2	2	2,890	1,445
LOT 3	2	35,486	17,743
LOT 4	2	37,396	18,698
LOT 5	2	25,284	12,642
LOT 6	1	27,834	27,834
LOT 7	1	12,658	12,658
LOT 8	1	27,810	27,810
LOT 9	1	28,940	28,940
LOT 10	1	7,830	7,830
TOTAL	15	232,226	168,649

thanks and hope I have explained my problem in detail.

[its_anandrjs]

Check this on your new thread

aggr