want comma at thousand seperator in text object

[mbp198]

I  am using a formula in a Text Object that is calculating certain value and giving a result the formula is

=ReportingCurrency&num(
sum(AGGR([FIN-AP-TA(CuC)], [FIN-AP-ADN],[FIN-AP-ACD],[FIN-AP-CC], [FIN-AP-FY]))

-
sum(AGGR([FIN-AP-TA (CuC)],[FIN-AP-ADN],[FIN-AP-ACD],[FIN-AP-CC], [FIN-AP-FY]))
,' ###0; -###0')

I have tried several different editing the code but no luck .  I want comma ,  at thousand separator this formula returns  number like 2434343224 without any comma

I want result like 2,434,343,224 I have tried to change the last bit of formula to ,' #,##0; -#,##0') but getting no luck and result is wrong with this. I did some research on this issue and came across '#'&Chr(39)&'##0','.',Chr(39)) which does not work in this case as well.

[swuehl · Accepted solution]

Try

num( ..., '#,###.','.',',')

Like

= num( 123456789, '#,###.','.',',')

i.e. specify the decimal and thousand separator and add decimal separator to format code.

[mbp198]

Thank You swuehl

[varaprasad0816]

Thank you for your answer, which helped me.

Regards,

Vara