Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
you meant
You were using Qty for your Total Units... Try this
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...