Pls. suggest me a good Pattern for a decimal field

[srinivas1506]

Hello

Pls. help me by suggesting a good pattern for a decimal field of amount value, my issue is as below

The lengths are as below,

I specified the Pattern for this field as below (its as --> null{}|zero{}|num{($z9,999.99)}|num.decimal{}), pls. note i did't put any Pattern in EDIT tab

1) But, when user entered the vaue am getting as on the form,

But i want the above as just either $1.10 or $1.1

2) also, am getting as below for another value,

But i want the above as just either $0.60 or $0.6

3) another case as below,

But, i want the above looks like as just $12,345 (if possible, if its not possible thats OK)

4) When the form is rendered on the browser am seeing the field as below,

But, once user put the cursor/clickedon the field the zero is defaulting as below,

but, i don't want to default the zero as above, just having blank is wanting (if its possible then thats nice, if its not possible thats OK), actually, i have another decimal field as below with the Pattern, (pls. note this field has also a EDIT ppatern as well)

The EDIT pattern is as below,

so, this field appearence on the form rendering is as below,

Once the user put the cursor / clikced the field the fiel looks like below

having this is fine for me instead of defaulting zero as described in issue # 4

Pls. suggest me a good pattern to meet all my above 4 issues

Thank you

[whyisthisme]

The number pattern you want is num{$zz,zz9.zz}

[Former Community Member]

It seems you have too many things going on in the data validation pattern, clear that out, then select from the "select type" field $1,234.21. That should fix it and must be done on all fields.

I also use this pattern on a regular basis: num{($z,zzz,zz9.99)}

You can cut and paste it as well.

[srinivas1506]

Thank you.

But, as am using 'VIEWER'S SYSTEM LOCALE' system is not giving the options like $1,234 as shown in my 1st pic.

If i use 'DEFAULT LOCALE' then, i am seeing these options of $1,234.......but, my form is also meant for EUROPE, where in the $ is not currency, hence i started using the VIEWERS SYSTEM LOCALE

Thank you

[whyisthisme · Accepted solution]

So use Viewer's system locale and just put the pattern as:

num.currency{zz,zz9.zz}