I am hoping that you guys could help me, my task seems a simple one but I don't know how to do it.
Basically, I have a record that shows me the level of stock for today, and I have a table that records dates and changes made to that stock. What I need to do, is take today's result, and subtract the changes made from yesterday. I need to get this data to show for the last 13 weeks (91 days worth of changes)…
I'm going on the training course in a few weeks, which will hopefully stop me from nagging you guys! But as always, you're help will be most appreciated.
The attachment shows the data we will be using, the chart shows the forecasted sales for the last 13 weeks and next 13 weeks. I am trying to add the actual stock figures using the table in_mstr_m for in_qty_oh_m for the last 13 weeks (different tables will be used for the next 13 weeks, but same theory applies).
The stock changes are in a table called tr_hist, fields tr_qty_chg and the dates them changes applied are tr_effdate.
