I want to perform a calc (see “@Compare” formula below) on Group 4 subtotals. I’d like to sum the result of this calc "@Compare" in the higher groups (Group 1, Group2, Group 3).
I am unable to use the Crystal’s Summary function (I assume because the result of “@Compare formula” is in a group section and not in the detail section). Same problem with running total. “@Compare” is not available to summarize.
@Compare formula = If column A> Column B then Column A else Column B
Example Groups and Sections
Column ID: A B C
Group 1 – Job Subtotal Group #1 CC sum of @Compare formula
Group 2 – CSI Subtotal Group #2 CC sum of @Compare formula
Group 3 – CC Subtotal Group #3 CC sum of @Compare formula
Group 4 – Cat Subtotal @Compare formula
Detailed Trans Section
Also - Users want to drill down to the “Detailed Trans” level
Can somebody recommend a direction? My other attempts (in progress):
1. A subreport to summarize the “Detail Trans” section and pass Cat Subtotals from subreport to Main. This will allow my main report’s detail section to be “Cat” thus allowing Crystal summary.
2. A formula in the detail section that summarizes amounts base on Cat value. Link an “On Demand Subreport” if the user needs to drill down to detailed trans level.