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
PaymentDate
Convert Payment_Date From:
MM-dd-yyyy
PaymentDate
%j
Payment Days
Convert PaymentDate To:
Custom
Submission_Date
%j
Submission Days
Convert Submission_Date To:
Custom
Days to Payment = [Payment Days]-[Submission Days]
Unit Cost = [Unit_Price]*[Qua...
C:\Users\av931lk\AppData\Local\Temp\Engine_17060_12e4fd2edb47442c8a547b3c26a41757_\Engine_19512_12b0b57091a145d6ae75034c7fdbebe3_.yxdb
Single
Profile
Horizontal
Practice Exercise 3