Small precision values loading probelm

[#1]

Hello, I want to load the small precision values from DB and I got zero values only. Here is the example:

I have value in the db table like -1E-7 and qlikview loads this values as -0.

I want load those exact values & display either number format or DB table format .

Please help me ...

[cesaraccardi]

Hi,

Have you tried using the num# function when loading the field from DB? Something like this:

num#(Field, '############')     as Field

You probably will need the num function to specify the resulting format as well:

num(num#(Field, '############'), '############')     as Field

PS: I am not sure about the mask you should use here.

Kind Regards,

Cesar

[maxgro]

this isn't in a load but it should works