How to format comma separate in text object

[#1]

I tried to have comma separate between the value in the text object, any idea this can be achieved?

[Anonymous]

Heok

Try using this as you text box expression:

     ='$ ' & num(round(sum({1<keyExpType={'Tier1Capital'}>}exposure),1),'#,##0')

Best Regards,     Bill

[#3]

hi

try to use num() format

[#4 · Accepted solution]

try according to this example

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

	Setting 1	Setting 2
String	35,648.00	35,648.00
Number	35648	35648

[CELAMBARASAN]

Change all you expression like this

=Num(Round(Sum({1<keyExpType={'Tier1Capital'}>}exposure), 1), '$ #,##0')

[saumyashah90]

Do this,

If you need a integer

Num(FieldName,'#,##0')

If you want two decimal

Num(FieldName,'#,##0.00')

If you want any number

Num(FieldName,'#######,###')

For % in any

just add % at the end

for example

In decimal

Num(FieldName,'#,##0.00%')

[#7]

[varaprasad0816]

Yes,It is working fine.

thank you

Regards,

Vara