Forum Discussion
dwanajw
Sep 18, 2019Copper Contributor
Pivot Table Values not matching Source values (Max Date)
My pivot table is changing the value of the source data to a different number, even though the cells are formatted exactly the same. I have a table containing dates of calls with timestamps for i...
- Sep 19, 2019
Yes, it works like this
Actually your timestamp has seconds and milliseconds. If add data to data model creating Pivot Table you have correct result. If not - Pivot Table rounds milliseconds.
JKPieterse
Sep 20, 2019Silver Contributor
Hi Sergey, I didn't know that.
Funny enough, if you change the format of the source data to general and then create a normal pivottable it does get the correct precision.
Funny enough, if you change the format of the source data to general and then create a normal pivottable it does get the correct precision.
SergeiBaklan
Sep 20, 2019Diamond Contributor
Hi Jan Karel,
It also rounds in formula bar
That's only formatting, but if hit enter in formula bar milliseconds will be rounded. Perhaps same story with some other operations, don't know.
- JKPieterseSep 23, 2019Silver ContributorYes I know about that indeed, thanks.