Format numbers with 2 parameters

marcel_olmo — Tue, 06 Feb 2018 16:10:30 GMT

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.

Re: Format numbers with 2 parameters

sunny_talwar — Tue, 06 Feb 2018 16:17:31 GMT

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"

];