I am needing to divide weekly tons delivered late per carrier delay by total weekly tons reported. For example: I want to find data for the week of 9/10/2018 Backorder TonsDeliveredLate divided by total TonsReported in the same week. (285/17,349). This should equal 1.64%.
However, I am using:
And it's giving me 2.43% (seen in the table below). Does anyone know of a better calucated column I could try?
Could you please share some sample data to have a test or post your data structure if possible?