Thousands separator

[Former Member]

Hi Experts!!

I've a Table View with several fields, one of them is a numeric field with the Local format option marked. In my case that means the output field has 2 decimal places.

If I unmark the Local format option, to change the number of decimal places, I only have the possibility to have a Comma for a thousand separator. Is there a way to have a point instead of a comma?. Maybe via Formula?. If I unmark the local format option, I could see the system works with an Expressión, for exemple If I want a value wiht zero decimal places and a comma for thousand separations, the expression the system use is:

NSTR(@P_FIELD, "C.0)

I try to change that C for several values (P,D), but I don't have the expected result...

Anybody has the same problem?.

Best Regards.

Emilio.

[former_member203343]

Hi Emilio,

What's your VC version? In different versions you have different answers.

Natty

[Former Member]

Hi Natty

We've 7.0 version.

Emilio.

[former_member203343]

Which SP level?

[Former Member]

Hi Again Natty!

GML Version: 700.13.0027

Client Version: 700.13.0.1

VCServer version: 700.13.0.1

Flex Version: 700.13.0.1

Portal Content version (HTMLBkit): 700.13.0.1

Portal connector version: 700.13.0.1

Emilio.

[Former Member]

Hi

Done!, using this Formula works.

REPLACE(NSTR(@P_VALUE, "C.0"),",",".")

NSTR returns a text value, so with a replace function I could do it!.

Emilio.