I don't know the difference between group and report footer. I created my TOTAL formula on report. I used the fields from the reports in my formula.
When you mentioned footer, I was thinking Page Header, Detail, etc. Well, it's under Detail if that is helpful.
I appreciate your help.