0

More detailed number formatting?

Is there a way to further control the decimal places beyond the standard settings in the format menu? For example, I'd like to display only one decimal place for percentages rather than two.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • You might want to try something like the following in a Formula where the .5 deals with the rounding of to 2 decimal places by default:

    concat(string(int((schema_name.table_name.column_name_measure * 10) + 0.5) / 10),"%")
    
    Like
Like Follow
  • 1 yr agoLast active
  • 1Replies
  • 87Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.