Quantity and gross weight showing as ### instead of numbers

[ngreddy1982]

Hi good morning all,

My report showing #### under quantity column and #### under gross weight column , when i take mouse and hoover on it it is showing value, please help how can I change them to numbers  instead off #####.I had same in date column , I have changed expression to Date("order date") under dimensions tab, so its showing date instead of ####.

[sunny_talwar]

May be you just need to extend the width of the column or go the numbers tab and change the format to show just integer....

[ngreddy1982]

Hi Sunny ,

there is no expression under number tab, and I have extended width as well.

[sunny_talwar]

Would you be able to show a screenshot?

[MK_QSL]

Have you formatted those fields at back end?

If yes, can we have the format here?

[viveksingh]

Can you post a sample document?

[avinashelite]

I feel number might too long !! so that its not able to accommodate in the space/width you have provided

can you try like

expression /1000000 and check your able to see the number ??

[ngreddy1982]

[#9 · Accepted solution]

Just right click on the respective column and select option fit to column then this issue has been resolve.

[ngreddy1982]

I have not formatted any fields Manish.