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!

Comments

  • trafalger
    trafalger Chicagoland, IL 🟠

    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.Β 

  • GrantSmith
    GrantSmith Indiana πŸ₯·

    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!**
This discussion has been closed.