Num Format with Hashes

[nigel987]

Hi, I want to display numbers with thousand separator '.' and two decimals.

Data:

LOAD * INLINE [

    Test, Zahl

    1, "5,89"

    2, "1000,5"

    3, "15465486,53"

];

NoConcatenate

Temp:

Load

Test,

Num(Zahl,'#.##0,00')

Resident Data;

Drop Table Data;

But my numbers get displayed with hashes. How can I change that?

Test	Num(Zahl,'#.##0,00')
1	6.##0,00
2	1001.##0,00
3	15465487.##0,00

KR Nigel

[Anonymous]

Good Day,

The the below:

Num#(Zahl,'#.##0,00')

Regards,

[nigel987]

Hi,

it still doesn't show the thousand separators

Test	Num#(Zahl,'#.##0,00')
1	5,89
2	1000,5
3	15465486,53

But this is better than before! Thanks

[Anonymous]

It is just because the table has been INLINE loaded, so it pulls through with the Comma in it, if you are pulling from a numerical format it should be correct.

Regards,

[nigel987]

When I use this file as a basis, it still doesn't show the thousand separators

Data:

LOAD Test,

     Zahl

FROM

yourPath\TestFile NumFormat.xlsx

(ooxml, embedded labels, table is Tabelle1);

NoConcatenate

Temp:

Load

Test,

Num#(Zahl,'#.##0,00') AS Zahl

Resident Data;

Drop Table Data;

[chinnuchinni]

Hi ,

you can use bellow;

LOAD Test,

     Zahl,

     Num(Zahl,'#,##0.00') as Zahl2

FROM

XXXXX ;