The matrix cell has to display the value as it is if its nonzero with leading special character

[uma_mahi]

Hi All,

Input :     Col1  Col2     Col3
               AA    $1,045   xxx
               BB     $0         yyy

Col2 : Decimal number, currency format. 
The matrix must display the Col2 value as such if its > 0  and if its 0 then 0 without the $ symbol.

your input please?

[ray_codex · Accepted solution]

IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency")) 

[uma_mahi]

Thank you so much, its working. 

[uma_mahi]

I did it using power query,
Col2 => Decimal , Col2_copy => text
if [Col2_copy] = "0"
then "0"
else Text.Combine(
{ "$",
[Col2_copy
})
Output : $1045 , 0 [ since the datatype of the column changed  to text , "," are gone. Is there any way to copy the data as such including its format?