Thousands Format in Text Label

[microwin88x]

Hello!

Is there any way to show in a Text Label Object, for example the number 35275 as 35.275? (In Thousands)

What function could I use?

Thank you!!!

[giakoum · Accepted solution]

num(fieldname, '#,##0')

[Gysbert_Wassenaar]

Use the num function: =num(35275,'#.##0' , ',' , '.')

[Anonymous]

why not simply divide the number by 1000...something like this

='Number in 1000s is '&35275/1000

replace 35275 with your field name.

also, you could use num function and keep an eye on what your thousand separator is. if you need a decimal for 1000 separator, you will have to SET it in the script in your main tab (ThousandSep)

[its_anandrjs]

Hi,

Use Num function.

Thanks & Regards

[#6]

When new QVW's are started there is a section of settings that are created for you including the thousands separator. If you change them and then apply formatting you'll get your result

SET MoneyThousandSep =',';
SET MoneyDecimalSep ='.';
SET MoneyFormat ='$#,##0.00;($#,##0.00)';

[maxgro]

you can try and copy format-code parameter of num function from here

[its_anandrjs]

Hi,

Use some thing like this

num(35275, '#.##0')

and set thousand separator like

SET ThousandSep='.';

in script editor

Thanks & Regards