my % formula that i have working is doing it's job for the details portion but what i'm trying to figure out is how to get it to work on the group totals and footer fields as well.

what i'm using is this:

whileprintingrecords;

if Sum ({field1}, {group}) = 0 then
   0
else
   Sum ({field2}, {group}) * 100 / Sum ({field1}, {group})

it works as it should but at the end of my group i have a totals field that i cannot figure out how to get the percentage on and also the report footer that shows the totals of the report that i cannot figure out the percentage on.

any help would be great!

thank you!!

well i made a formula field  "Total %" that i placed into the group footer but it returns "0" instead of a variant of the total records.