This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to solve Practice Exercise 3 and I am totally lost. I don't know how to Subtotal.
Here is the question we have been asked to solve:
Combine the customer information in "Start 3.1" with the "Order Details". Ensure both the "Order Date" and "Ship Date" columns are formatted as "date" datatype.
Find the number of days to ship after the order was placed for each line item. Also calculate the subtotal for each line item (discount and shipping are flat costs, not per quantity). Finally, find the Total cost for each order, the "Total Saved" for each order, and the minimum days to ship any line item within each order.
I got as far as making a Total column with Unit Price + Shipping Cost-Discount. After this I am lost. Could somebody help or give an idea where to go next, i.e. the Subtotal question?
Any help is welcome. I have attached my workflow here.