Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!
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

Avatar

Level 2

Exactly what I needed Doug. Thank you!