Accounting number format

UI Bakery Roadmap 🏗️
1

Could we have a way to display numbers in a table as Accounting Format (where negative numbers are represented in parentheses).

Using the mapper, I can put something like this:
{{value < 0 ? ‘(’ + -1 * value + ‘)’ : value}}

But I can’t add the parentheses without breaking that I have set the column to be “Number” type (the cells that were negative values become “N/A”)

If I change the column type to “String” then my summary row can no longer be Sum, and switches to Count.

Which would then make me think I need to come up with custom summary code.

2

Hi @paulm,

I think it’s valid to have this format, but depending on how many people vote for this, it might take longer until it’s added (if at all).

Until then, use the mapper you showed and the following summary function for the String column type:

{{parent.value}}.reduce((acc, curr) => acc + curr.stock, 0)

(Replace “stock” with the name of your property)