More decimals

[Anonymous]

Hello, I have this problem.

I need more decimals in one numbre, QV only show me 14 decimals and I need 20.

Can you Help Me?

[#2 · Accepted solution]

You can multiply the number by 1.000.000. This way you´ll be getting all the desired decimal.

[CELAMBARASAN]

You could do the format as

Num(FieldName, '####.###########################################')

Have 20 #'s after the decimal separator.

[#4]

Hi,

I'm not sure that it is possible because QlikView cannot handle numbers over 14 digits. If there is more than 14 digits it is converted to text.