Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Pattern of Decimal field for amount in Euros

Avatar

Level 2

Hi,

I need to display an amount in a certain format and the patterns provided do not cover my need.

Is it possible to have this following type of display?

 

.    1.092,23            (decimal separator is ,)

.    1 1.092,10

.    -115.262.55       (negative sign in front of the amount)

 

Thanks for any help.

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi

See here for more explanations: https://help.adobe.com/en_US/livecycle/10.0/DesignerHelp/WS92d06802c76abadb-39e0256b129b8b00b71-7ed1...

and regarding your 2 patterns:

For the comma as a decimal set the locale on the pattern which matches your requirement, eg num(de_DE){z,zzz,zz9.zzz}

Kosta_Prokopiu1_0-1608107250507.png

And for the minus sign - well normally a negative value will have automagically but you could add a "-" in the pattern. Just be aware that negative numbers will then show 2 of them! num{-zzzz9.zzz}

Kosta_Prokopiu1_1-1608107362582.png

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

Hi

See here for more explanations: https://help.adobe.com/en_US/livecycle/10.0/DesignerHelp/WS92d06802c76abadb-39e0256b129b8b00b71-7ed1...

and regarding your 2 patterns:

For the comma as a decimal set the locale on the pattern which matches your requirement, eg num(de_DE){z,zzz,zz9.zzz}

Kosta_Prokopiu1_0-1608107250507.png

And for the minus sign - well normally a negative value will have automagically but you could add a "-" in the pattern. Just be aware that negative numbers will then show 2 of them! num{-zzzz9.zzz}

Kosta_Prokopiu1_1-1608107362582.png

 

 

Avatar

Level 2
Hi Kosta, thanks a lot for your answer, it works well, thank you very much 🙂