Thousand seperator in a computed text

HCL Domino Domino Forum
1

Hello,

I have a computed text field. This looks up to numer field. The value in the computed text field bring down the decimal point but not the thousand seperator.

For e.g the number fiel value displays as 123,456.789

But the computed text field displays as 123456.789

How do I get the thousand seperator in to the computed text. I do not want to use a computed for display or computed field as the number of changes will be too much.

I was thinking along the lines of RegExp or formula equivalent of FORMAT LS Function.

Any suggestion welcome.

Thanks

2

Subject: Re: Thousands separator in computed text

If you read the documentation of the @Text function, you will discover that it has a second argument that lets you specify how you want the number formatted.

I should note, that though it isn’t required in this case, changing a computed text to a CFD field is not such a huge change. I don’t understand why you would hesitate about that.

3

Subject: @text function

4

Subject: Thanks

Hello,

Thanks for the reply. That was really straightforward and I should have done my research more thoroughly. Thanks once again.