Format Number Field with Commas | Community
Skip to main content
D
DavidStein
New Participant
October 22, 2020
Solved

Format Number Field with Commas

  • October 22, 2020
  • 2 replies
  • 819 views

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.
    Best answer by Doug_Den_Hoed__AtAppStore

    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

    2 replies

    D
    DavidSteinAuthor
    New Participant
    October 22, 2020

    Exactly what I needed Doug. Thank you!

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    October 22, 2020

    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

    Terms & ConditionsAccessibility statement

    Loading footer...