Hi,
I'm working with a pivot table in 2013 counting dates in various fields. I added several calculated fields to determine conversion rates from one category to the next and all works well. I am attempting to add further calculations, but for some reason the same fields I have been using are not counting the dates properly anymore.
For example in one column I have a count of all students showing Admit Date and in another for Enrolled Date. They are counting fine. I also have a calculated field showing Enrolled/Admit for the conversion, also working fine. But when I try to add a new calculated field, the field does not give me an accurate count and seems to be working with the Date Integer instead of a count, no matter what I do to the fields. I've even tried modifying the existing calculated field to show a different formula and it all falls apart.
Any ideas?
I'm working with a pivot table in 2013 counting dates in various fields. I added several calculated fields to determine conversion rates from one category to the next and all works well. I am attempting to add further calculations, but for some reason the same fields I have been using are not counting the dates properly anymore.
For example in one column I have a count of all students showing Admit Date and in another for Enrolled Date. They are counting fine. I also have a calculated field showing Enrolled/Admit for the conversion, also working fine. But when I try to add a new calculated field, the field does not give me an accurate count and seems to be working with the Date Integer instead of a count, no matter what I do to the fields. I've even tried modifying the existing calculated field to show a different formula and it all falls apart.
Any ideas?
