2 Replies Latest reply: Aug 22, 2013 5:40 AM by test test

# Combine Stock Quantity with Prices of a Date

Hello,

I have the following tables.

1. A table with the current stock on a specific date. This date is only calculated when a stock mutation is made. The table looks like this:

ArticleDateMutationStock
Article110-08-2013+1010
Article112-08-2013+515
Article209-08-2013+4040
Article220-08-2013-1030

2. A table with the value (price) of an article on a specific date. These prices can change daily.

ArticleDatePrice
Article110-08-2013€ 20
Article111-08-2013€ 25
Article208-08-2013€ 10

I want to calculate the value of the stock at the end of the month. Problem is, the dates dont always match. How can I use the latest price in a month? I prefer not to merge the tables, cause I think it will result in an unclear data structure.

• ###### Re: Combine Stock Quantity with Prices of a Date

I think that the best solution would be to combine the two tables in one, and then create another table just for the month end stocks and prices, but if you prefer not to combine, this should be the solution

PFA

• ###### Re: Combine Stock Quantity with Prices of a Date

Really helpful mate, thanks alot! I will be able to do what I wanted thanks to your example.

EDIT: I'll keep this unanswered till I actually fixed it. Maybe i'll have some more related questions.