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
You were using OrderQty for your Total Units... Try this
Sum([OrderQty])/Sum(TOTAL [OrderQty])
How about you try this
Sum([Qty])/Sum(TOTAL [Qty])
Sum([Sales $]/Sum(TOTAL [Sales $])
Thanks Sunny this gives an incorrect % value for both units and sales
Would you be able to share a sample?
Script doesn't help... what do you get when you use this?
Sum([Qty])/Sum(TOTAL [Qty])
Class of Trade | No of Customers | Total Units | Total Sales | % Units | % Sales |
AGENCY | 19 | 79,728 | 247,643 | .26% | .30% |
DECORATOR | 70 | 2,064,481 | 4,535,474 | 6.14% | 5.10% |
DISTRIBUTOR | 98 | 38,485,801 | 108,168,466 | 85.92% | 89.82% |
MANUFACTURER | 3 | 52,531 | 138,689 | .03% | .04% |
RETAIL | 9 | 412,017 | 356,427 | 1.31% | .41% |
WHOLESALE | 45 | 2,433,573 | 4,398,952 | 5.29% | 3.53% |
- | 33 | 328,100 | 675,878 | 1.05% | .79% |
277 | 43,856,231 | 118,521,528 | 100.00% | 100.00% |
Can't really say what might be wrong here without looking at your dimensions, expressions and chart settings... may be someone else can help...
Best,
Sunny
Can you share the app ?
I only have one dimension and that is the trade all expression attached
Sorry no because too much company info