Format numbers with 2 parameters

[marcel_olmo]

Hi guys, I have a field with the following numbers :

In this case I'd like to get only two possible numbers : 0,00 and 0,01.

I'm trying the following :

Numbers:

Load *, num(Number ,'#.##0,00') as NumberFormated;

LOAD * INLINE [

    Number

    "7,0390448e-018"

    "4,0030448e-018"

    "0,006"

];

But it outputs this :

What am I doing wrong?

Regards, Marcel.

[sunny_talwar · Accepted solution]

You might have to use Round() function

Numbers:

Load *, num(Round(Number, 0.01) ,'#.##0,00') as NumberFormated;

LOAD * INLINE [

    Number

    "7,0390448e-018"

    "4,0030448e-018"

    "0,006"

];