formula help -- embed number within text 1

[dswitzer]

I have a formula like :

"We see you have grown by " + 
cstr({g_letter_mgmt_change_data_1.changeCt}) +
" locations."

Which results in:

We see you have grown by 1036.00 locations.

How can I format that number within the formula to return 1,036 instead of 1036.00?

Thanks.
Dave

 

[lbass]

Change the formula to:

"We see you have grown by " +
cstr({g_letter_mgmt_change_data_1.changeCt},0) +
" locations."

-LB

 

[crystalabc]

Use this to separate thousands:

cstr({g_letter_mgmt_change_data_1.changeCt},0,",")

 

[dswitzer]

Cool. I didn't know cstr had any options at all!

Thanks.

Dave