G
Guest
In my group footer I have the following calculation
=IIf([elm/ven]="e",Sum([total cost])," "). This calculation is working
correctly, however I am now trying to get a report total for the "e" group.
I copied the same calculation into the report footer but it is totaling the
entire report (both the "e" groups and another group "v"). It seems to be
ignoring the if statement to only sum the e's. I've gotten this to work in
the past just not today. Any suggestions would be great.
=IIf([elm/ven]="e",Sum([total cost])," "). This calculation is working
correctly, however I am now trying to get a report total for the "e" group.
I copied the same calculation into the report footer but it is totaling the
entire report (both the "e" groups and another group "v"). It seems to be
ignoring the if statement to only sum the e's. I've gotten this to work in
the past just not today. Any suggestions would be great.