cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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%.

 

 

 

4.PNG

 

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

1 REPLY 1
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?

 

Regards,

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.