Friday, May 21, 2010 8:02 AM
I tested PowerPivot with really big numbers and have a look - it simply shrinks the precision of my data without any notification or warning.
Well guys - there are cases out there which will need to analyse big values...
Any ideas - comments on this?
Even more confusing is that the table preview shows the data correct (!):
The values are converted into the precision of a decimal type (R8 internally) and displayed as scientific value (e.g. 123...E+27).
But no comment on the loose of precision!
Friday, May 21, 2010 4:13 PM
Numeric is an old Sybase data type that is still in SQL Sever for backward compatibility. You should check if the same problem appears if you choose decimal as the data type?
Friday, May 21, 2010 5:59 PM
Same behavior - numeric and decimal in SQL give the same effects to PowerPivot.
Saturday, May 22, 2010 10:30 AM
This is something that happens in Excel 2010 as well.
Enter something like 123456789123456789123456789123456789 into a cell and format it.
You will see 12345678912345600000000000000000000
Seems to be an Excel issue.
Saturday, May 22, 2010 11:23 AM
The number precision in Excel is 15 digits.
Have a look here: