Skip to Content
0
Apr 20, 2014 at 06:53 AM

How can we format a number without the thousands separator (comma) by Formula?

2259 Views

Hi!

I am developing a report in CR 2008.

I am using Groups and Toggle Group Tree in my report.

I want a field called "LineNumber" to be displayed in the Group Tree as foll:

1001

1002

1003

1004

1005

etc

My first attempt is to put this formula in the relevant X-2 box:

TOTEXT ({usp_01.LineNumber})

My Group Tree displays as follows:

1,001.00

1,002.00

1,003.00

1,004.00

1,005.00

etc ....... (not exactly what I want)

Next, I try:

TOTEXT({usp_01.LineNumber},0)

My Group Tree now shows LineNumbers without decimals as foll:

1,001

1,002

1,003

1,004

1,005

etc ...... (better than before)

But how to get rid of the comma? What formula to use?

Thanks

Leon