Format Number Field with Commas | Community

Level 2

Solved

Format Number Field with Commas

Forum|Forum|5 years ago
October 22, 2020
2 replies
825 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

Doug_Den_Hoed_AtAppStore

Community Advisor

Accepted solution

Community Advisor

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

DavidSteinAuthor

Level 2

Exactly what I needed Doug. Thank you!