calculated columns, sum, dividing

[KaitlynS4]

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?

[v-danhe-msft]

Hi @KaitlynS4,

Could you please share some sample data to have a test or post your data structure if possible?

Regards,

Daniel He