afternoon all,
its kindof a basic one but my formatting is well of as I am getting the normal "contains and error" message
I have a pivot table showing
Sum of Turnaround Days
count of Turnaround Days
and I want to add a calculated field of "sum of Turnaround days /count of turnaround days" and same for others.
=SUM('Sum of Turnaround Days' /'Count of Turnaround Days' )
Yet this is generating an error.
Without the "Sum of" excel defaults to count so I get "1".. (in all cases "sum of" is always larger than "count of" so I should always have a number great than 1).
any thoughts
steve
Bookmarks