Pivot table and divide one calculated column by another column

[smansberger]

<style></style>I have one column that counts all the document names on a certain date and sums the values on that day. I am wanting to add a column that will divide the Duration by the sum of the Doc Names on that day. I cannot get the calculated field to do the correct calculation.

I am trying to get the 'Sum of Validation Duration' / 'Values Count of Doc Name'.... I cannot get the Values count to be accurate.