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

    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.