Blogger
Share this content
0
5
1710

Adding percentage calculation to Sage 50 P&L Report

I want to modify the Profit and Loss (Actual Budget & Variance) Report  so that it shows the percentage of one detail line total as relating to the total Category cost of a different Category.  Its a variant of the calculate costs as a percentage of total sales type of facility.In this case the Sales Category contains several lines of detail, one of which Sales Type A is the divisor.  The second Category is Direct Labour, comprising Labour Type 1 and Labour Type 2.  I want to define an expression which will calculate the Direct Labour Category cost as a percentage of the Sales Type A, for the actual and budget, this period and year to date.

Can this be done?

Replies

Please login or register to join the discussion.

05th Jul 2012 11:10

Core Blimey

Anything complicated is far better done on Sage data after extracting it to a spreadsheet. There are plenty of weak programming areas that are hidden except when you try to do high faluting things within the program.

Johndon I am sure will come to your rescue on this, but as a user of many years, I would rather not tinker too much with the Sage reports - I've more interesting things to do with my time.

Thanks (0)
avatar
05th Jul 2012 11:17

cor blimey moonbeam

Yes normally I would run a mile and Excel is a GREAT friend, but my boss has set his heart on this ...

Thanks (0)
avatar
05th Jul 2012 11:20

Cor Blimey indeed...

Moonbeam wrote:
Johndon I am sure will come to your rescue on this

I'll see what I can do but I'm not sure it is possible...

John

Thanks (0)
avatar
05th Jul 2012 11:19

cor blimey moonbeam II

We used to be able to do this easily in line100, but then Sage improved it ...

Thanks (0)
avatar
05th Jul 2012 11:33

This *%*%&^% report

Thanks John.  In terms of the nominal accounts that make up the figures, what I need is to print the calculation (as below) on the Direct Costs category sub total line.

The calculation is <sum(nominal accounts 50**-51**) / sum(nominal accounts 40**)>

I don't know (I'm not that conversant with Sage 50 reports yet beyond the basics) but that seemed to me to be the way to think of it.

Thanks (0)