Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
10 years ago

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 how to widen it.  Any ideas?

 

 

1 Reply

  • samdthompson's avatar
    samdthompson
    Memorable Member
    10 years ago

    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