Overview:
When processing the data file for VInsights in CRM, the error occurs: Incorrect decimal value:'' for column 'xxx' at row 1.
Root Cause:
There are blank values in the csv data file. In Excel, it looks like this:
Solution:
Update the csv data file, replace the blank values with 0.
VInsights is now called Fixed Reports for Sales and Activity Data and can be found using this link: Loading Call Activity Data for Fixed Reports.
Related Documentation:
CRM Help Documentation: Loading Sales Data Files
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.