Number Format

[#1]

I've the following number: 10,01234

And I want to represent them into this format: 10.012,34

I already try all the formats in number tab but nothing returns what I want.

What comes closest to what I want is :##.##,###

Anyone have any idea?

Thanks

[Peter_Cammaert]

Like this?

=num(YourField * 1000.0, '#.##0,00', ',', '.')

[#3]

Thanks Peter, but it doesn't returns the format that I want

[Peter_Cammaert]

Where is your "number" stored? Is it a text string?

It does work for me though. This script

RawData:

LOAD 10.01234 AS Number AUTOGENERATE 1; // Raw Binary number, default format

Data:

NOCONCATENATE

LOAD *, Num(NumberFormat1 * 1000.0, '#.##0,00', ',', '.') AS NumberFormat2;

LOAD *, Num(Number, '#0,00000', ',') AS NumberFormat1

RESIDENT RawData;

DROP Table RawData;

produces this in a table box (no number tweaking)

See attachment.

Best,

Peter

[#5]

If I multiplicate by 1000 I get the number correct in my chart, however the value of my pop up it isn't correct...

[#6]

Is a bar chart, its a result of a calculation

[Peter_Cammaert]

Please post an example document with this phenomenon, or we will have to guess what exactly you are doing and that may take a while. Thanks

Peter

[jagan]

Hi,

Try like this

=Num(Replace(FieldName, ',', '')/100, '#.##0,00', ',', '.')

Regards,

jagan.

[t_chetirbok · Accepted solution]

Hi, cause chart display sum, you should use:

so your result will be like this: