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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started