I'm having a small issue which I don't know how to solve. I have a table containing our sold Machines and one table with our invoices. I created one fact out of these two. Now I need to calculate the redemption of my machines over time. The table simplified looks like below:
Load *, recno() as ID INLINE [
Start, End, SerialNo, PriceSold
15/01/2011, 15/01/2016, AAAA, 18000
08/08/2011, 08/08/2016, BBBB, 36000
03/04/2012, 03/04/2017, CCCC, 72000
Every machine has a 60month redemption period (PriceSold/60 will give me how much the machines redemption is each month).
I want to achieve the total redeption of each machine on a yearly base.
Year 2011: 6600€ (Machine AAAA: 3600, Machine BBBB: 3000)