Summary using Formula not insert-summary 1

[neronikita]

I need to sum several fields in each group, and then I need to be able to use these in another formula. When I use insert-summary it summarizes how I want it, but I can't seem to use that in another formula without generating an error. Is it possible to write the formula to sum each group, and the grand totals, and then use that to get an average? Right now, when i do a sum formula, it gives me the grand total number under each group (so they are all equal to the grand total number, not the group number). I'm a little rusty on Crystal, and am using 2008, so any advice would be ever so helpful. Thanks!

Grouping on month
Need to sum Miles, Line Haul, Total Rate, Fuel Surcharge, TR-FSC for each month, then for grand total. Then I need to get rate per mile average for each month and grand total. Sounds simple, but it's not giving me the correct numbers...

Thanks!

Di

 

[IanWaterman]

Assuming you have grouped report on date and in the change group drop down this section will be printed, select each month.

You can use formula like

Sum ({miles}, {datefield}, "monthly")

or for report total

sum({miles})

Ian

 

[neronikita]

The field is actually just the number of the month and is called MonthLoaded, so the report currently has 1,2,3,4, and 5. How would I adjust your formula for that?

Thanks!!
Di

 

[IanWaterman]

Sum ({miles}, {Monthfield})

 

[neronikita]

Oh, that was simple - thanks! lol I'll try it.

 

[neronikita]

That did what I needed it to do perfectly! Thanks so much for getting me over the hump!