Calculated Field Coming Back as Zero

[biotbravo]

Hello and thank you for reviewing this thread. I am trying to insert a calculated field that shows the on time performance of shipments. I am pulling from a table that shows the tracking number the shipping lane I want to analyze and the OTP ( ontime performance ) code. I am inserting a pivot table and choosing the OTP status field, Tracking number count, and inserting a pivot table. The calculation I am putting for the pivot table is the OTP field divided by the count of tracking numbers and I am getting a zero for the calculation instead of a percentage. For example, in the last row of average of fields the cell should be the calculation of 7 / 11 = 64%. Any ideas of what I am doing wrong?

 

[Asbestos_Jen]

For your average column, what are the settings you currently have? I got your expected with these settings:

 

[biotbravo]

Thank you so much for your response. I am still not getting the results you are getting but it is what I need to get. Can you view my selections in the image I uploaded?

 

[Asbestos_Jen]

My "average" field in the ∑ values section is set up as shown in my screenshot above, and based on "OTP Status" (I achieved the same results with "Tracking number"). Your designated "Sum of average" field may be part of the problem. Is that the result of your custom calculated field formula (dividing one count by another) rather than by the total? Try removing that and just working within the ∑ values section.

Yours:

{edited grammar for clarity)

 

[biotbravo]

Thank you. I will try doing that and post back.