Format Number Field with Commas | Community
Skip to main content
DavidStein
Level 2
Oct 22, 2020 7:15 PM UTC
Solved

Format Number Field with Commas

I have a number field that is showing as valueformat=customDataLabelsAsString when I am in text mode. I went to format it to include commas (valueformat=doubleAsInt) but when I did, the values disappeared from my report. What is the best way to format a number (text field) in a report to include commas?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    Oct 22, 2020 7:41 PM UTC

    Hi David,

    I suspect you're looking for doubleAsRounded, which I looked up by:

    • adding a numeric column to a view
    • highlighting that column
    • clicking the Advanced Options link
    • changing the Field Options dropdown from 1234 to $1,234
    • switching to Text Mode so I could see the valueformat

    Regards,

    Doug

    View reply

    2 replies

    DavidSteinAuthor
    Level 2
    Oct 22, 2020 8:08 PM UTC

    Exactly what I needed Doug. Thank you!

    Translate
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    Oct 22, 2020 7:41 PM UTC

    Hi David,

    I suspect you're looking for doubleAsRounded, which I looked up by:

    • adding a numeric column to a view
    • highlighting that column
    • clicking the Advanced Options link
    • changing the Field Options dropdown from 1234 to $1,234
    • switching to Text Mode so I could see the valueformat

    Regards,

    Doug

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...