Numeric Fields Show Separator After 4 Places

Question

Curious to get other's thoughts.&nbsp; We have not enabled the new Grid Reports in our primary application.&nbsp; We have one application used by a small group that does have new Grid Reports enabled.This application (with Grid Reports enabled) has summarized data from our primary application.&nbsp; I was updating the data today and noticed the totals have the comma separator after 4 places.&nbsp; So, 100000 is displayed as 10,0000.&nbsp; When last updated, I'm pretty sure the comma separator was after 3 places.I see in the field properties a select of Show separator after 4 places or Show separator after 3 places.&nbsp; This appears to be a new option with the default of 4 places.&nbsp; For all the numeric fields, I'll need to manually change to 3 places.I could not find anything in the release notes about this option.&nbsp; Has anyone seen anything related to this?&nbsp; Is there any way to change the default to 3 places?&nbsp; I have a feeling this is going to be overlooked quite a bit when adding new numeric fields.&nbsp;&nbsp;

markshnier__you · Answer

Quickbase defaults to have a numbers up to 9999 show with no comma and when you hit 10,000 it shows the comma. If you want to force number like 9999 to show as 9,999 then you have to change that setting for every field. I assume the reasoning for that behaviour is that it makes the reports a little less wide.

I also wish there were some kind of global realm or at least application level default setting for that, but there is not. If you put in a user voice feedback, suggestion, and post a link back here I will vote for it.

hueyal · Answer

I'm not looking to have 4 digit numbers display the comma.&nbsp; I want the comma displayed after 3 places for numbers 10,000 and above.&nbsp; See screenshot.&nbsp; The second column has a total of 183,006 but is displayed as 18,3006 (based on the default show separator after 4 places of the field configuration).

markshnier__you · Answer

Not sure what to say.&nbsp; Maybe its a bug you need to report.&nbsp; Can I see a screen shot of he field configuation settings?

hueyal · Answer

Also, this attachment has the field properties.&nbsp; The default is showing the separator after 4 places.&nbsp; So, each field will have to be updated to change to 3 places.

markshnier__you · Answer

... feels like a bug to me.&nbsp; You can report it via the ? icon at the top right of any page in your app.

Forum Discussion

Numeric Fields Show Separator After 4 Places

7 Replies

Related Content

Format Numeric Value 2 Decimal Places

Formula-Numeric Field Returning Null Instead of 0

Add Numeric Fields together if a checkbox is checked

Sample Data not reflecting Default Value (Field Properties, Numeric-Currency)

Qrew Tip: Table From Field