Order Details
Final State
Initial State
Practice Exercise 3
Combine the employee information from the last exercise with "Report Details" to find the Total, Total Saved, and days to payment for each report.
Combine the employee information in "Start 3.1" with the "Report Details". Ensure both the "Submission Date" and "Payment Date" columns are formatted as "date" datatype.
Find the number of days to payment after the report was submitted for each line item. Also calculate the subtotal for each line item (discount is per unit and shipping is a flat cost). Finally, find the Total cost for each order, the "Total Saved" for each order, and the number of days it took to pay the report in full.
Start 3.1.yxdb
Start 3.1.yxdb
Report Details.yxdb
Report Details.yxdb
Final State - Exercise 3.yxdb
Final State - Exercise 3.yxdb
Payment_Date
MM/dd/yyyy
Payment_Date1
Convert Payment_Date From:
MM/dd/yyyy
Days to Payment = DateTimeDiff([Payment_Date],[Submission_Date],"days")
Saved = ...
Horizontal
Practice Exercise 3_solution