Question: EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the approver; however, someone other than the employee should approve a
EXCEL PROBLEM: Employees should not approve their own expense reports. Usually their manager is the approver; however, someone other than the employee should approve a claim for segregation of duties purposes. Test the data to see which employees approved their own expenses. (Hint: Create a true/false calculation.) What are their names? How much, in total, did the employees from question 4 approve for themselves?
I have a data set with these categories:
Expense Tracking Number
Approver Employee Number
Approver Name
Expense Approved Date
Reimbursement Paid Date
Expense Type
Description
Expense Category
Ticket Number
Ticket Status
Transaction Date
Vendor
Employee Number
Employee Name
Department
Payment Description
Mileage Rate
Miles
Number Guests
Transaction Amt
How do I create this TRUE/FALSE calculation to solve this?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
