Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

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!