need to convert number(float) to string and concatenate with brakets

[ahsanlhcgov]

Hi Guys, 

I have a financial statement in which I want to show the negative inside brackets. 

At the moment I have applied conditional formatting to change the color to red but need to add brackets to.

Please can someone tell me how can I achieve this. 

 Column name is Variance.

[v-frfei-msft · Accepted solution]

Hi @ahsanlhcgov,

We can add a calculated column using the formula. Then we can get the result as we need.

Column = IF(Table2[Variance]>=0,""&Table2[Variance]&"","(" &Table2[Variance]&")")

For more details, please check the pbix as attached.

https://www.dropbox.com/s/wmoyw4q8xohsjve/need%20to%20convert%20numbe3.pbix?dl=0

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @ahsanlhcgov,

We can add a calculated column using the formula. Then we can get the result as we need.

Column = IF(Table2[Variance]>=0,""&Table2[Variance]&"","(" &Table2[Variance]&")")

For more details, please check the pbix as attached.

https://www.dropbox.com/s/wmoyw4q8xohsjve/need%20to%20convert%20numbe3.pbix?dl=0

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @ahsanlhcgov,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank