Calculation of Gross Profit Percentage
There is one income statement report and there was no Gross Profit Percentage in that report. I need to calculate the Gross Profit Percentage. I did it by using Gross Profit/ Net Sales.
I did that by adding a new row in the Income Statement report itself.
But the report is an expandable report and when the user is trying to dig through the data, the rows in which the Gross Profit and Net sales are there are moving to some other rows.
So is there any other way to do this dynamic so that the Gross profit Percentage will be calculated on the fly at the data retrieval time.
I tried to add a new account in the account.xls. But it is not allowing me to do that. I do not know why.
Any help greatly appreciated.