Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Format Number Field with Commas

Avatar

Level 2

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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 solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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