Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I would like to Cost by Sale ratio for every main account, my scenario is something like this;
year | month | main account | cost | sales |
2017 | 1 | 100 | 120 | 800 |
2017 | 2 | 100 | 125 | 820 |
2017 | 3 | 100 | 130 | 845 |
2017 | 4 | 100 | 95 | 700 |
2017 | 5 | 100 | 124 | 810 |
2017 | 6 | 100 | 132 | 825 |
2017 | 7 | 100 | 145 | 845 |
2017 | 8 | 100 | 127 | 801 |
2017 | 9 | 100 | 135 | 850 |
2017 | 10 | 100 | 128 | 825 |
2017 | 11 | 100 | 160 | 900 |
2017 | 12 | 100 | 140 | 890 |
how to right below expressions in a straight table?
cost/Sales% | WA% | diff from WA% |
15% | 16% | -1% |
15% | 16% | 0% |
15% | 16% | 0% |
14% | 16% | -2% |
15% | 16% | 0% |
16% | 16% | 0% |
17% | 16% | 1% |
16% | 16% | 0% |
16% | 16% | 0% |
16% | 16% | 0% |
18% | 16% | 2% |
16% | 16% | 0% |
Sorry to compute Cost by Sale ratio
This
Expressions
=Sum(cost)/Sum(sales)
=Avg(TOTAL Aggr(Sum(cost)/Sum(sales), year, month))
=Column(1) - Column(2)
The second expression might change if you need a total average by main account
=Avg(TOTAL <[main account]> Aggr(Sum(cost)/Sum(sales), year, month))