Hi folks,

how should I properly set a numberMask field if I want to set an number with a 2 decimal places?

In my application I have 2 languages defined: 1. EN - decimal separator "." and thousands separator "," 2. CZ - decimal separator "," and thousands separator "."

How should I properly set a numberMask, so it will always display a number with a 2 decimal places, but also respecting a language setting?

Example: Selected Language = EN 100 => 100.00 12.1 => 12.10 1234.56 => 1,234.56

Selected Language = CZ 100 => 100,00 12.1 => 12,10 1234.56 => 1.234,56

numberMask = "#,##" does not work

Thanks Tomas

asked 13 Oct '12, 14:58

Tomeo's gravatar image

Tomeo
162143
accept rate: 3%


You should use "0" instead of "#" to force digits.
"#.00" or "0.00" should work for you.
See also http://theformspider.com/learningcenter/using-number-mask/

link

answered 13 Oct '12, 15:10

oskansavli's gravatar image

oskansavli ♦♦
3604
accept rate: 45%

edited 13 Oct '12, 15:11

Hi guys,

I need to right align numbers that CAN have two decimals. For example values can be 123 or 234.55 or 63451.25.

This works correctly with format mask #####.00. However, with this mask there is no difference between zero and NULL values. Both are displayed as 0.00. It is however important to see the difference between zero and NULL.

Is there a work-around to show NULL values completely empty?

KR, Jan Willem

link

answered 28 Nov '16, 03:25

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131226
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3
×2

Asked: 13 Oct '12, 14:58

Seen: 1,446 times

Last updated: 28 Nov '16, 03:25


© Copyright Gerger 2017