View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Pivot table formula (calculated field) result is incorrect

Update:
After playing with the underlying data to ensure consistency in the values,
I have fixed the Shares summarization problem - this data field now shows the
correct count and sum.

However, my problem remains with the calculated field for Value except that
now the value is 3 times the correct value for fund 427 and 8.411 times the
correct value for fund 460.