Skip to Content
Sep 01, 2012 at 07:37 PM

SAP BPC: calculation by using script logic


Hi experts, 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

Income Statement Year 2010 Year 2011 Year 2012 Turnover 1000 1100 1200 Cost of Sales 500 550 600 Gross profit 500 550 600 Margin 0 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. Thanks Warren