Account schedule Gross Profit calculation?

rstols

I am trying to insxert a line in the account schedule that will calculate the gross profit %.

Example:
Row #, Description
10 Sales
20 Gross Profit
30 Gross Profit % (The formula I used was (20/10)*100, but it is giving me the wrong answer.)

I used 30/10 before and it would give me an answer of 0.28 which is correct but the moment I tried to convert it to % by multiplying it by 100, I am getting a weird answer.

Any help or suggestions please?

Thanks,

Alex_Chow

rstols wrote:

I am trying to insxert a line in the account schedule that will calculate the gross profit %.

Example:
Row #, Description
10 Sales
20 Gross Profit
30 Gross Profit % (The formula I used was (20/10)*100, but it is giving me the wrong answer.)

I used 30/10 before and it would give me an answer of 0.28 which is correct but the moment I tried to convert it to % by multiplying it by 100, I am getting a weird answer.

Any help or suggestions please?

Thanks,

Change your Row No. to be alphanumeric.

rstols

Thanks for the feedback.

Are you saying that I should change the row number from '30' to '30a' or something like that? If that was what I should have tried, then it didn't work.

Any other suggestions perhaps?

Thanks
Rudy

Savatage

for example how I figure out a profit% would be something like

(((Sales - Cost)/Sales) * 100)

not Just ((Sales/Cost) * 100)

rstols

I am familiar with the calculation but that is not my problem.

Alex mentioned to: 'Change your Row No. to be alphanumeric' and I was not sure what he meant by that.

Savatage

for mine i use line no like

Liabilities
L10
L20
L30
ETC

Assests
A10
A20
A30
ETC

Equity
E10
E20
E30
ETC

Totals
T10
T20
T30
ETC

Perhaps that's what he means

rstols

Thanks, I will try that and see if it works.

Rudy