Negative Numbers in parentheses using Decimal Number and Comma

[aishak12]

Hi All, 

I am using this format to have parentheses in my decimal number data type. Is it possible to add in a comma to this format? 

Its currently greyed out.

0.;(0.);

Thank you

[tex628 · Accepted solution]

Hi @aishak12 , 

Try this:

[Anonymous]

Hi  @aishak12  ,

According to your description, I create some data:

Here are the steps you can follow：

1. Create calculated column.

Column =
"("&FORMAT(ABS('Table'[sqlimport]),"#,##0")&")"

2. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

have you tried to change your regional settings 

and then if you dont customize the format you should be able to add the thousand separator which I am assuming you are trying to do.

[selimovd]

Hey @aishak12 ,

if you use manual formatting options you cannot add the standard ones. They are grayed out as you already realized.

Sorry, I didn't full understand how the result should look like. Can give me an example how the result should look like, then I can give you a proposal.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[aishak12]

Thank you for your help! 

The number in SQL is imported as 

-2130

I would like the number in my table matrix to populate as 

(2,130)

Is this possible