Calculation of Void transactions

[donsi]

Hi everyone,

This might be very simple but I quite don't get the result I want. I have a report built on the query which has Emp name, guest name,amount and void check box.

I didn't wanted to have record deleted so i designed a check box for void transactions which shows up on the report and I want to get total amount of the voided transaction as well as count. When I tried below expression, it gives me the correct count but not the correct amount.

=Sum([Void])*[Amount]


Please see attached report. What expression would I need or would it required some VBA (just a beginner on that).

Thank you

 

[boerbende]

try
=sum(iif(void=true,[amount],0))

 

[plog]

Shouldn't 'Void' be a status?

 

[donsi]

try
=sum(iif(void=true,[amount],0))

Thank you boerbende. I would never have figured out.

 

[donsi]

Shouldn't 'Void' be a status?

They way it is reconciled, I couldn't have Void as Status. But this would have been an option for me if formula from boerbende didn't work.