Formatting a calculated column

Question

I don't know what I'm missing, but I am using a calculated column in a report with numbers formatted with zero decimals and commas after 3 spaces. The calc column shows a differences between two of the column entries but it is not formatted and I cannot find where to do so. &nbsp;Help

quickbasecoachd · Answer

Are you saying that you cannot see where to control that formatting or the formatting is set but its not working? &nbsp;The formatting is set right where you have the formula built.

scottgrund · Answer

Where is this formatting for the calc column where I can set separation with commas for 1,000?

quickbasecoachd · Answer

Not tested but try App Properties and let us know if that worked.

scottgrund · Answer

Thanks. That worked. For some reason I did have that set earlier and it changed. It would be nice to have a universal app properties to set at the account level so you don't have to remember what you prefer when setting up a new app. Again, you saved the day.&nbsp;

quickbasecoachd · Answer

I quite agree, , that should be a realm account  levelsetting.    Most of us don't wake up each day and create a new app for a different region of the world.

Forum Discussion

Formatting a calculated column

Related Content

Calculation/Performance Limits Inquiry

Calculating 1.5 pay

Default column widths on embedded reports obscuring data

Format Formula URL field

Calculating number of days between two date fields