I'm trying to get some help with how to write a query. I have a table that contains the Year and a value EC. Using that table, I am trying to produce the table below.
Year BBF EC Int Total 2013 - 25 1.00 26.00 2014 26.00 85.96 3.44 115.40 2015 115.40 100.05 4.00 219.45 2016 219.45 205.96 8.24 433.65 Total from
previous year4%(BBF+EC) BBF+EC+Int
I'm not sure how to write the sql query as the total is dependent on the BBF, but the BBF fields also needs the total from the previous year.
Any help would be appreciated.
Thanks