Hi, Im trying to sum values from a single column using rollup, but the result is formatted in thousands instead of the complete number. Does anyone know what Im doing wrong? Im attaching a acreenshot to be more clear. In that example the correct number should be $1,706,086 (I had to displayed up to 3 decimals in order to see the complete number). In the other screenshot you can see all the numbers I want to sum.
Is your computer set to a region that swaps , and . to represent thousands and decimals? I know some regions of the world do that. It looks like your thousands separator is being treated as a decimal.
I’d first check the region settings on your computer. If that seems fine, then try removing the $ from your number column. If that still doesn’t work, try removing the thousands separator from the number column. I think I’ve seen weird things with math mixing with extra text characters, such as dollar symbols.
It may ultimately be a bug, but those would be some good debugging steps.
3 Likes