Quick Filter Number Formatting

Reply
Highlighted
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!

Highlighted
Orange Belt

Re: Quick Filter Number Formatting

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. 

Highlighted
Purple Belt

Re: Quick Filter Number Formatting

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):
1

10

2

3

...

9

 

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!**
Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!