Showing results for 
Search instead for 
Did you mean: 
KaitlynS4 Frequent Visitor
Frequent Visitor

calculated columns, sum, dividing

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:  



Capture 4.PNG



And it's giving me 2.43% (seen in the table below).  Does anyone know of a better calucated column I could try?



Capture 5.PNG

Community Support Team
Community Support Team

Re: calculated columns, sum, dividing

Hi @KaitlynS4,

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



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.