I am creating an input schedule using three dimensions i.e account in the row, time in the column and another trading dimension in the column as well. Now I have to input data and have to calculate income statement for the year lets say 2011. in year 2012, i do the same thing and create income statement, but this time i have to include slight difference. this time, i have calculate gross profit margin using previous year gross profit. I explain it bit more below
Cost of Sales
Gross profit (2011)/Grossprofit (2010)-1
Gross profit (2012)/Grossprofit (2011) -1
Is there any ways i can write a sript logic to calculate this gross profit margin (calculation explained above). Currently, I am using excel formulla. but i know this is just a quick fix not the right solution. Could anyone please help me out.