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.
|