## Crystal 2011 - running total of a formula

## Crystal 2011 - running total of a formula

(OP)

I have a formula to calculate sales by department based on each job. I need to be able to summarize the department totals that I have calculated with a formula.

I have two groups by job then by department.

The department sales totals are a formula based on the percentage of sales total for each job. I want to add all calculated department sales into a total.

example:

job dept sales

10 10.00 for this job dept 10 is 20% of sales

20 30.00

30 10.00

123 50.00

10 10.00 for this job dept 10 is 13.33% of sales

20 45.00

30 20.00

234 75.00

Totals by job 125.00

Totals by dept

10 20.00 in total department 10 is 16% of sales

20 75.00

30 30.00

I have two groups by job then by department.

The department sales totals are a formula based on the percentage of sales total for each job. I want to add all calculated department sales into a total.

example:

job dept sales

10 10.00 for this job dept 10 is 20% of sales

20 30.00

30 10.00

123 50.00

10 10.00 for this job dept 10 is 13.33% of sales

20 45.00

30 20.00

234 75.00

Totals by job 125.00

Totals by dept

10 20.00 in total department 10 is 16% of sales

20 75.00

30 30.00

## RE: Crystal 2011 - running total of a formula

You need to define how many depts in advance and then create a formula for each Dept

@dept10 sales

If JobDept = 10 then sales else 0

You can then sum each of these in report footer and then have a GT Dept Formula

@Dept10 GT%

Sum(@Dept10 Sales)%Sum(sales)

Ian