Calculating the difference of two dates for each category (1 Viewer)

[accessuser33]

Hello,

I need help with calculating the difference in price of a product within the same column of a table.

The table looks similar to this:

Product, Product description, date, maturity 1 price , maturity 2 price

I need to calculate the difference for each maturity for date 1 and date 2, and eventually date and date(n +1)

For example the table looks like this:

row 1: Product 1, description 1, 01.01.2019, 1 USD , 1 USD
row 2: Product 1, description 1, 01.02.2019, 2 USD, 2 USD

then the result needs to be:
result in new table: Product 1, description 1, diference between 01.01.2019 and 01.02.2019, +1 USD, +1 USD


I have gotten the result when there are two different tables and each one contains a single date. But I need all the data within one table, i.e multiple dates. And I need to calculate the change in price for each date.

Thanks!

 

[June7]

Review http://allenbrowne.com/subquery-01.html#AnotherRecord

 

[accessuser33]

Thanks for the link, but unfortuantely I still did not find a solution.

 

[June7]

You need to pull value from another record of same table? Allen Browne's article shows how to do that.

 

[plog]

Please demonstrate your issue with data. Include 2 sets:

A. Starting data from your tables. Include table and field names and enough data to cover all cases.

B. Expected results of A. Show what data you expect to end up with when you feed in the data from A.