Listbox - incorrect number format for frequency.

[#1]

Hi,

I have an issue where all of my listbox frequency counts are a set number format with no comma separated thousands.

I seam to not be able to change the number format.

[jagan]

Hi,

I think there is no direct setting for this, we need to use List box Expression for this, please find attached file for solution.

Regards,

Jagan.

[Gysbert_Wassenaar]

The number settings are for the field of the listbox, not for the additional expressions you add. Try adding the num function around your expression: num( ...myexpression... , '#,###')

[#4]

I have the same problem, but NUM function doesn't help.

[#5]

Maybe this can help you.

[#6]

Hi Leonardo,

Thanks, but I am working on a personal license, so I can only import my own stuff or otherwise I can't open anymore what I have created myself. I don't know if it is just a threat, but I don't dare to try it out.

It is a simple listbox newly created and then added a sum([# Departures Performed]) as a expression. I tried the Number tab of the Properties dialog, but nothing helped. I then added in the expression the NUM function, but no succes either.

Is it possible to send some screenshots? By the way I am working with version 11.

Thanks,

Patrick

[#7]

Num( sum([# Departures Performed]),'#,###')

The result is

[#8]

Thanks Leonardo,

I checked my expression again and somehow I used NUM# instead of NUM. I read the help about the NUM# function and now understand the output that I got. I changed it to NUM and now it is okay.