Issue - Can't read number format with dots and commas
in progress
Y
Youssef Hounat
in progress
Y
Youssef Hounat
Thanks Guillaume! this is very interesting then, i will take a look into this type of document and see what we can do on the indexing side to improve this accuracy! for now i am marking this post as "in progress" as we are investigating how it works!
Y
Youssef Hounat
Hey Guillaume, thanks for reaching out with this feedback! Can you let me know what the correct way to interpret this format would be? Usually we see "." as thousands seperators and "," as decimal points based on your Excel formatting, in this case it looks like they are mixing them? or should we treat this as having 3 digits after the decimal point?
G
Guillaume
Youssef Hounat: Hello Yussef, thanks for your quick reply.
In this example of Financial Statements the dot is used as decimal seperator and the comma as a thousand separator.
My understanding is that the algorythm gets confused because there are three digits for the fractional part of the number and this looks like the 3 digits that would be separated by a thousand separator.