Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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
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

View solution in original post

2 Replies

Avatar

Correct answer by
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

Avatar

Level 2

Exactly what I needed Doug. Thank you!