Difference in decimal places between formatted value and value

[GiovanniVolpe]

Hi everyone, querying CDBHistoric data table I see that there is a difference in the number of decimal places between the formatted value (second column) and the value (third column) and the value as real (fourth column). How can I increase the number of decimal places for the value (and value as real) too?

[sbeadle · Accepted solution]

Perhaps its the default for 'unformatted' numbers in the list display.

If you want the number without the units, use the SQL:

FORMATVALUE( 12.5 USING '#0.0000' ) returns '12.5000'

[AndrewScott · Accepted solution]

Floating point numbers are formatted to six significant digits in lists.

This comes from the default format for floating points numbers in the CRT printf function. For details see Format specification syntax: printf and wprintf functions. Lists use the g type field with the default width and precision.