cost in % of sales

[ctm66]

Hello,

I want to express all cost in a % of sales. I work in exact, have a group of account that make a reportgroup, I have a report that is sorted on accountgroup, so all accounts of sales are grouped in a total of sales, all accounts of salary are grouped in a total of salary, the reports should look like :

Actual Budget
Sales 5.000 100% 6.000 100%
Purchase cost 2.000 40% 2.500 42%
Salary 1.000 20% 1.000 17%
Accomodation 750 15% 750 13%
Transport 500 10% 750 13%

Result 750 1.000



How can I calculate every group total in a % of group total sales.

Thanks.

 

[lbass]

Actual Budget
Sales 5.000 100% 6.000 100%
Purchase cost 2.000 40% 2.500 42%
Salary 1.000 20% 1.000 17%
Accomodation .750 15% .750 13%
Transport .500 10% .750 13%

I don't have a clue how you got the "Results" line or what that refers to. Your sample was confusing because you forgot to show the decimals in the last two lines. You also didn't really show use the fields you were working with, so I'll just explain the method you should use: To make the sales totals available for the percentages, use conditional formulas like this:

//{@ActualSales}:
if {table.acctgroup} = "Sales" then {table.Actual}

//{@BudgetSales}:
if {table.acctgroup} = "Sales" then {table.Actual}

Then you can write percentage formulas like this:

//{@Actual%}:
sum({table.Actual},{table.acctgroup})% sum({@ActualSales})

//{@Budget%}:
sum({table.Actual},{table.acctgroup})% sum({@ActualSales})

-LB

 

[ctm66]

Hi LB,

Thanks, and sorry I wasn't clear enough. The result comes from sales minus cost ( 5000-2000-1000-750-500= 750,-)

The formula works this is what I made from it :
//{@ActualSales}:
- if {AccountClasses.AccountClassCode}="20" then {@bedrag_maand}
//{@Actual%}:
- sum({gbkmut.bdr_hfl},{AccountClasses.AccountClassCode})% sum({@ActualSales})*-1

Now the next thing is, there are more costcenters, when I select 1 cost center, it goes right, when I select more costcenters, the @Actualsales is the sum of sales of all cost centers and I want the calaculation per costcenter.

A second thing is, in the exact database, both actual and budget are in the same table, to select only the actual I use :

if {gbkmut.transtype} = "N" then {gbkmut.bdr_hfl}, how can I make sure that I only sum the actual, with the above formulas, the sum of actual plus budget comes out.

 

[ctm66]

Hi,

I solved the problem with the total of actual and budget, the only thing now is the problem with more cost centers, and then the total of sales per cost center.

 

[ctm66]

Hi LB,

Solved, used a running total and now it works, that will say for they actuals, thanks for setting me in the right direction.

 

[lbass]

You don't need a running total--you just needed to add the group condition to the summary as in:

sum({@ActualSales}, {table.costcenter})

-LB