Discussions

Expand all | Collapse all

Formatting a calculated column

  • 1.  Formatting a calculated column

    Posted 08-24-2017 19:45
    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


  • 2.  RE: Formatting a calculated column

    Posted 08-24-2017 20:00
    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.


  • 3.  RE: Formatting a calculated column

    Posted 08-29-2017 13:52
    Where is this formatting for the calc column where I can set separation with commas for 1,000?


  • 4.  RE: Formatting a calculated column

    Posted 08-29-2017 14:05
    Not tested but try App Properties and let us know if that worked.


  • 5.  RE: Formatting a calculated column

    Posted 08-29-2017 14:11
    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. 


  • 6.  RE: Formatting a calculated column

    Posted 08-29-2017 14:27
    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.