Crystal 2011 - running total of a formula 1

[jchewsmith]

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

 

[IanWaterman]

This is never easy and requires a bit of a compromise.

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