I have a table that I am trying to get a calculation out of. Tbl_Source_Data is the name and the columns that will factor in are:
What I am trying to do is get a service level calculation for shipped volume that was shipped on or before the Due_Date. I would have no problem in Excel but this is so different. It would be Shipped_Volume, that was shipped on or before the due_date, divided by the sum of shipped_volume.
Thanks for any help that you can provide
Solved! Go to Solution.