I have a Crystal Report that shows different groups(or departments) utilizing the groups in Crystal Reports. I then used some formulas to calculate Attached and Unattached assets in each group. Now I wish to show a total for the column of Attached and Unattached, what is the best and simplest way to do this?
Update Okay I have been able to use a running total on @countattached that gets me close to what I need, the only problem is that it wants to add the last group total to the next group. The report is set up so the Employee (I.E. Jane Doe) and under that Employees name are Groups that, that Employee adds reports too such as Parks, Water, Streets , Etc. those Groups have a field across from them for Attached and Unattached with a total for both together at the end for each Group. I need a total for each Group under the column of attached and Unattached..
Okay I finally figured it out if you have a series of columns that have sums for individual groups(parks,streets,water) under employees all you need to do to calculate the totals of those groups is right take the formula that has the sum for those groups, , such as (@countAttached). Then do a Running Total in the Running total dialog box, you can then set it to reset after each individual that those groups apply to then you have a those totals for that column. You just repeat this process for any other Columns you have.