Thank you for replying. Your formula did not work exactly.
The table above is part of a buying template (see below)
When we buy we look at the actual components sold .
The totals figures you see are totals of FEEMS. So when we buy, we look at the totals . for JHB - PO , the total does not appear which makes it difficult (more awkward) to work out stock required.
By the way:
- PO stands for Purchase Order
- The figures are all multiplied by component qty. So for eg, Sales for FBCP12 in May-13 is actually 10. Therefore the sales of component (FEEMS) is 20.
Hope this helps.
Your formula given did not work exactly.