Edit a group sum
I have a field that is a sum, that is currently in the value of feet and I need in to be in miles. Can I do a calculation inside that field to dived by 5,280 and show the value as miles.
Ted Shaw replied
Is the Sum of ACF.Shape in feet or Miles ??
Assuming it is in feet then you would divide by 5280 as Dell and Abhilash have said, but if you already have miles, then what I think is your issue is that you are trying to use the sum Wizard to generate the total of field that is already a sum....... and Crystal won't let you do that.
You can only do that from a field at the Detail level ( Which is not currently showing on your report as you show in your screen shot )
.... so add it to the report. ( and suppress the detail section so it doesn't show )
add a new group ( Grand total )
That group goes between the Group 1 ( county? ) and the old group 2 .
( when you do that crystal will re-number the groups and the new group will be 2 and the group for the surface type will become 3 )
and then do a group sum for that group ( new group 2) and place that in the group footer section ( as a general practice all sums should go in the footers not the headers .... unless you have some special reason)
Place the new sum in the report right below the other sum.
Does that work better??