Dollar amount format not displaying correctly

[Rsanjuan]

Hi, 

I am trying to figure out why the sales figures are not displaying:

It's showing #,0.00#,0.00

I thought it may be simply a column width issue on the report, but I cannot figure out how to widen it.  Any ideas?

[samdthompson]

Hi, welcome to the forum. to me it sounds like a format issue. try creating a new column with something like:

currency = FORMAT(Data[Value],"$ #,##0.00"). if it throws an error try there will be something wrong in the origional column. If thats the case go back through the query to fix