Forum Discussion
Dollar amount format not displaying correctly
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 h...
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