Subtract Data

[Dayna]

Good Afternoon,

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.

Kind Regards,

Dayna

[#2]

Where is your source data? (SQL Server, text files, etc.)

[Dayna]

Hello,

It is coming from ODBC Data Connection from a Progress Database.

Kind Regards,
Dayna

[#4]

could you upload a QV with an example of your data?

[Dayna]

Hello,

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.

Kind Regards,
Dayna

[Dayna]

,

[Dayna]

Hello,

Can anyone assist with the above please?

Regards,

Dayna