Calculation of Void transactions

donsi

Registered User.
Local time
Today, 12:21
Joined
Sep 1, 2016
Messages
73
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
 

Attachments

  • Report.PNG
    Report.PNG
    24.1 KB · Views: 99
Shouldn't 'Void' be a status?
 
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.
 

Users who are viewing this thread

Back
Top Bottom