Sum cost if yes/no = yes

[Matt W via AccessMonster.com]

I have a report grouped by "Date by Month", then by "Franchise", and sorted
by store number. Each Franchise has a number of stores that apply for credit
for damaged product. Its my job to sort requests and figure out who gets
credit or not. So each record shows STORE, then COST, and then DENIED. In a
form I simply type in the date, store number, the product number and click a
checkbox if the claim is denied. On the report it groups them and pulls the
cost of the product from a table, etc. How do I show total cost of yes and
total cost of no under each franchise?

I already have totals of yes/no's. =Sum(1-Abs([Denied])) and =Sum([Denied]*-
1). I just can't figure out how to tell it to add the total cost of yes
records by franchise, and the total cost of no records by franchise under the
franchise footer. Sorry in advance if my verbage is messed up but I think
that paints an ok picture.

Thanks.

 

[Matt W via AccessMonster.com]

I have a report grouped by "Date by Month", then by "Franchise", and sorted
by store number. Each Franchise has a number of stores that apply for credit
for damaged product. Its my job to sort requests and figure out who gets
credit or not. So each record shows STORE, then COST, and then DENIED. In a
form I simply type in the date, store number, the product number and click a
checkbox if the claim is denied. On the report it groups them and pulls the
cost of the product from a table, etc. How do I show total cost of yes and
total cost of no under each franchise?

I already have totals of yes/no's. =Sum(1-Abs([Denied])) and =Sum([Denied]*-
1). I just can't figure out how to tell it to add the total cost of yes
records by franchise, and the total cost of no records by franchise under the
franchise footer. Sorry in advance if my verbage is messed up but I think
that paints an ok picture.

Thanks.

Never mind. Answered my own question. It was staring me in the face. Slapped
myself for not seeing it. If someone else out there has a brain warp too
here's how I did it.

Denied =Sum(Abs([denied]-1*[cost]))
Approved =Sum(Abs([denied]*[cost]))