How to Display as negative Number (after dividing two negative values)?

[luisClive]

Dear Friends

question

How to Display as negative Number (after dividing two negative values)?

.. prefeable in brackets

Iam talking about "how to" display only , because if I use any " if conditions" the values change

[v-yangliu-msft]

Hi  @luisClive  ,

According to your description, I create this data:

Here are the steps you can follow：

1. Create measure.

Column1 =
var _1=
IF('Table'[amount1]<0&&'Table'[amount2]<0,
-1*DIVIDE('Table'[amount1],'Table'[amount2]),
DIVIDE('Table'[amount1],'Table'[amount2]))
return
"("&_1&")"

2. Result.

You can downloaded PBIX file from here.

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.

[Singaravelu_R]

create calcuate columns 

divide_value = -(DIVIDE('Table (2)'[column1],'Table (2)'[column2],0))

bracket = "("

bracket 2 = ")"

Column 4 = CONCATENATE('Table (2)'[bracket],'Table (2)'[divide_value])

column5 = CONCATENATE('Table (2)'[Column 4],'Table (2)'[bracket 2])

[Singaravelu_R]

[Singaravelu_R]

[amitchandak]

@luisClive , refer if this can help

https://www.accountingweb.co.uk/business/financial-reporting/power-bi-how-to-bracket-negative-number...

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-brackets-wit...