Forum Discussion

aishak12's avatar
aishak12
Helper IV
5 years ago
Solved

Negative Numbers in parentheses using Decimal Number and Comma

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

Need Help

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • aishak12's avatar
      aishak12
      Helper IV
      5 years ago

      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 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.