TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Formatting numbers with section separators
It would be nice to be able to use section separators when formatting numbers in order to specify a different format for positive & negative numbers (for instance, to display negative numbers in parenthesis with no sign), as described here:

https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings (search for Section separator)

Right now, using section separators with the Format function:

Format([field], "$#,##0.00;($#,##0.00)")

gives an error in TeamDesk.

So you have to use something like this for each number:

If([field] < 0, "(" & Format(Abs([field]), "$#,##0.00") & ")", Format([field], "$#,##0.00"))

ID
2152
Category
Setup
Author

Jorge Solá
Date Created
6/12/2026 4:25:59 AM
Date Updated
6/12/2026 4:25:59 AM
Status
New Idea
Score
20
Promoted By
Patricio BustosJorge Solá
Feedback
 
Back to Search Results