Quick Filter Number Formatting

White Belt

Quick Filter Number Formatting

I'm trying to remove the commas from numbers that are 1000+ in my quick filter. I can't for the life of me figure out how!

Green Belt

Not sure if it's best practice, but Domo is adding the commas since it's formatted as a number. Quick way to fix this is to make a beast mode that is Concat(`numberfield`) and then Domo will view it as Text. 


Sometimes I've had to do Concat(`numberfield`, '') and add a space too. 

Major Brown Belt

One thing to look out for though is that converting the number to a text field will cause Domo to sort it based on the textual representation and not the numeric number within the field.


For Example (text sorting):







The way to get around the textual sorting issue would be to left pad your numbers with 0s which just causes another display issue of having leading 0s.

**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.