Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session
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