Skip to main content
Question

Formatting a calculated column

  • August 24, 2017
  • 0 replies
  • 72 views
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
      This topic has been closed for replies.

      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.
      • ScottGrund
      • Author
      • Registered
      • August 29, 2017
      Where is this formatting for the calc column where I can set separation with commas for 1,000?
      Not tested but try App Properties and let us know if that worked.
      • ScottGrund
      • Author
      • Registered
      • August 29, 2017
      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. 
      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.
      Terms & ConditionsAccessibility statement