FranticIntern
New Member
- Joined
- Jun 13, 2018
- Messages
- 4
ID # | date | price | (after code) | ID # | Date | Factor |
001 | 1/1 | 5 | 5 | 001 | 1/3 | 2 |
001 | 1/2 | 5 | 5 | 002 | 1/5 | 3 |
001 | 1/3 | 10 | = 5 (Price) * 2(Factor) | |||
001 | 1/4 | 10 | =5 (Price) * 2(Factor) | |||
001 | 1/5 | 10 | = 5 (Price) * 2(Factor) | |||
001 | ... | 10 | = 5 (Price) * 2(Factor) | |||
001 | 1/10 | 10 | = 5 (Price) * 2(Factor) | |||
002 | 1/1 | 4 | ||||
002 | 1/2 | 4 | ||||
002 | 1/3 | 4 | ||||
002 | 1/4 | 4 | ||||
002 | 1/5 | 12 | = 4(price) * 3 (factor) | |||
002 | 1/6 | 12 | = 4(price) * 3 (factor) | |||
002 | ... | 12 | = 4(price) * 3 (factor) | |||
002 | 1/10 | 12 | = 4(price) * 3 (factor) |
<tbody>
</tbody>
I am trying to code so that I can match up ID # and Dates and multiply the price with its factor all the way to its last date.
Much help is appreciated, if you have any questions please ask and I will get back to you promptly.