Forum Discussion
ahsanlhcgov
Helper III
Helper IIIneed to convert number(float) to string and concatenate with brakets
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 br...
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
Hi ahsanlhcgov,
Does that make sense? If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank
v-frfei-msft
Community Support
Community SupportHi 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-msftCommunity Support
Community SupportHi ahsanlhcgov,
Does that make sense? If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank