Hi,
I have column called data ( datatype - numeric)
value in column = 0.000000000000000000000004567
when i query the column from database i am getting only 0 digit after float is not showing when i query
please any one help me to sort out this issue
How many characters do you want to display? That’s how many 0
s you need in your number formatting field on your table customer.
Right click the table, go to customizer, find your column, you should see something like
# are optional numbers and will only display if something is present, 0 are represent numbers that must be displayed.
If you changed your Number Format to #.000000000000000000000000000, it should show all the digits you just showed us, but that is a lot of zero’s and I can’t imagine it will look good on your table. I am unsure if there is a limit to the number of 0’s you can put after a decimal in a Number Formatting field, I’ve never had to deal with decimals as small as yours. You might want to, in your query, multiple by a million or a billion and just make note of the scale in the column header, along with changing the Number Formatting field.
1 Like