Mixed type column

[Anonymous]

I have a column that can contain number or characters(Mixed type). I don't understand why I get this value? Any explanation please?

[tresesco]

This itself is a number and not text. 'E' stands for exponent here. When a number is very large or very small, the number is represented in scientific notation (e). Search the web for more details.

[Anonymous]

How could I display the number in proper way?

[stig1984]

Change the number format for that field to either integer or fixed number of decimal places on the NUMBER tab of the report properties, or use the NUM function as veerendrakatikala suggests.

[girishsrini]

Hi,

Can you please send the screenshot of values from the column you are talking about. Unless text and number values are concatenated, shouldn't be problem for Totals.

[tresesco · Accepted solution]

You might want to change during load, like:

Load

          Num(NumberField, '(dec)') as NewNum