Formatting a calculated column

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.  Help
Photo of Scott Grund

Scott Grund

  • 390 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Are you saying that you cannot see where to control that formatting or the formatting is set but its not working?  The formatting is set right where you have the formula built.
Photo of Scott Grund

Scott Grund

  • 390 Points 250 badge 2x thumb
Where is this formatting for the calc column where I can set separation with commas for 1,000?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Not tested but try App Properties and let us know if that worked.
Photo of Scott Grund

Scott Grund

  • 390 Points 250 badge 2x thumb
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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
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.