accessuser33
New member
- Local time
- Today, 07:06
- Joined
- Feb 5, 2019
- Messages
- 2
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!
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!