I have a report with 5 levels of grouping. The details section is completely suppressed. The subtotal of the details in group footer 5 appears to a viewer of the report to be the lowest level of detail.
In addition to having a subtotal in group footer 5, I also subtotal the details in group footer 4. In an adjacent column of the report I use a formula to calculate the % each subtotal in group footer 5 is of the subtotal in group footer 4.
My report then has an addition column of data in the suppressed details section with the subtotals again in footer 4 and 5.
Next I apply the percentages calculated above to the subtotals of the second set of details in group footer 5. What we are doing here is showing the current year's budgeted tuition by residency/load and applying last year's mix of residency load to this year's data so I can seperate the difference between one years tuition budget due to residency mix as opposed to enrollment growth.
My issue is I can not show a subtotal in group footer 4 of my calculations in group footer 5 that multiplies the calculated percentages by the second set of details. There is no details section to sum. If a user selects the sum function with your active object being a formula or a subtotal sum is not one of the available functions in the drop down list.
My solution was to write a formula that simply adds the formulas in group footer 5. This does not work. The results obtained from this formula is the bottom item only from the set of formulas I ask Crystal to add.
I am sure other people have had similar issues and hopefully can help. I don't even really need the subtotal I am trying to get. It is just these reports go on to a bunch of older CPAs with little by way of computer skill. They will expect to see a subtotal just because it seems like there should be one and can't understand it's not like Excel where you can just add anything.
IP Logged
