Problem calculating correct percentages

[qlikmpate0]

I have a straight table, of trade, no of customers and sales and units.

I'm trying to calculate the % of sales and units using this expression, but getting incorrect figures for %Units and %Sales(see below)

this is the expression I'm using for %units - (Sum([Qty])/(sum([Qty - TOTAL - Present])*100))

and for %sales I'm using  (sum([Sales $]/[Sales - TOTAL - Present]))*100

example of %units

class of trade total unit/total units * 100 to get % units

eg 79,728/43856,231 * 100 = 0.182%

Do I need to put it in my script, of calculate as an expression?

Class of Trade	No of Customers	Total Units	Total Sales	% Units	% Sales
AGENCY	19	79,728	247,643	1.49%	2.07%
DECORATOR	70	2,064,481	4,535,474	12.38%	16.86%
DISTRIBUTOR	98	38,485,801	108,168,466	67.51%	69.18%
MANUFACTURER	3	52,531	138,689	.11%	.11%
RETAIL	9	412,017	356,427	.38%	.51%
WHOLESALE	45	2,433,573	4,398,952	6.76%	8.17%
-	33	328,100	675,878	11.36%	3.09%
	277	43,856,231	118,521,528	100.00%	100.00%

so confused on where I'm going wrong can someone relieve my misery.

Thanks in advance.

regards

M

[qlikmpate0]

Thank you so much I was totally missing the totals and getting confused with my total Qtys and sales.

Thank you so much for helping.

Thanks again.

[vvira1316]

you meant

You were using Qty for your Total Units... Try this

[sunny_talwar]

I meant that Mina was using OrderQty for Total Units instead of Qty...whereas her initial post was using this expression.. which made me think that she is using Qty...