Expand my Community achievements bar.

SOLVED

Problem with numeric field pattern

Avatar

Former Community Member

Hello!

This problem is driving me crazy!...

I've placed a float numeric field and used the following pattern:

     num{zzz,zzz,zzz,zz9.99}

This field should display and accept floating point numbers with 2 decimal places and in European format.

The default locale for this form is Portuguese (Brazil).

So... if I type something like 99999 the field displays correctly 99.999,00.

Now, if I type 99999.00, again the field displays correctly 99.999,00.

However, if I type 99999,00 (with a comma instead of a period, which is what I need)  the field displays 0,00.

Please, thank you for any ideas! 

Marcos

1 Accepted Solution

Avatar

Correct answer by
Level 10

The result you're getting is correct, because you pattern only allows a period to separate the decimal places.

Try the following edit pattern:

num{zzzzzzzzzzz9,99}|num{zzzzzzzzzzz9.99}

and this display pattern:

num{zzz.zzz.zzz.zz9,99}

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

The result you're getting is correct, because you pattern only allows a period to separate the decimal places.

Try the following edit pattern:

num{zzzzzzzzzzz9,99}|num{zzzzzzzzzzz9.99}

and this display pattern:

num{zzz.zzz.zzz.zz9,99}