Adobe Forms. Convert Decimal Display.

[Former Member]

I have a field with "zzz,zzz.99" but I need to display it like "zzz,zzz,z99".

Example, from 13,125.00 to 1,312,500.

Please help me!

Any ideas are valuable for me.

[Former Member · Accepted solution]

Thanks all! In conclusion I used this:

data. ... :initialize - (FormCalc, client)

$ = Floor($ * 100)

$ = Format("z,zzz,zzz,zz9", $)

Field Format: Text field.

Helpful links:

LiveCycle ES2 * Adobe LiveCycle Designer ES2

http://help.adobe.com/en_US/livecycle/9.0/FormCalc.pdf

http://partners.adobe.com/public/developer/en/xml/formcalc_2.0.pdf

[ali_eshaghibeni]

Hi

i`v done some complex scenario with java script, if you are using standard backend and your field is directly connected to Screen Fields then changing type of field may cause some problems due to nonconformity of field value and screen field, some data are different in display mode of Screens and database view, for interactive form scenario you can do this with javascript.

     var str = "Mr Blue has a blue house and a blue car";

     var res = str.replace(/blue/g, "red");

     The result of res will be:

     Mr Blue has a red house and a red car

Also refer to Adobe forum, you can try this:

          this.rawValue = this.rawValue.replace(/ü/,"ue")

find your solution here:

https://forums.adobe.com/thread/418751?tstart=0

like this if you think this is helpful,

Ali,

[former_member195570]

The decimal display is based on current user settings,change the settings and probably you will get the desired result.

[Former Member]

Thank you for your answer. But I need "multiply" this number by one hundred. I think i actually can do it in script area. I thought I can do it with pattern.

[former_member195570]

Hi Irina,

1. Go to Pallette-->Object-->Cell--->Make it as Numeric Field.

2. After this Go to Pattern-->Display-->where you will see all kind of display of a numeric field-->after         selecting the required pattern click OK..

3.Set the Locale:Default Locale , English(USA)

Screenshot for your reference: