Decimal places

[Former Member]

Hi Webi Experts,

I have troubles formatting my amount fields.

i'm relatively new to Webi so maybe this will sound like a stupid question. I searched the forum but couldn't find the answer until now.

I have numbers with two decimal places eg.

123,40

1.003,00

1.223.400,57

I do want to see two decimal places after the separator.

When using 1234,57 the zeroes after the decimal separator get lost. I get 123,4 and 1.003

I have tried different combinations of #.###,00 etc but sofar have not found the right combination.

Can anyone of you experts help me out?

Marco

[Former Member]

Hi Marco,

Try the following format:

#,#.00 or #,###.00

Regards,

Rohit

[Former Member]

I already tried this one and it added me two zeroes after the number.

I did have a problem with the international settings of my desktop so i tried to reverse dot and commas.

In the end it worked out. Thanx

Edited by: Marco Lamers on Dec 13, 2010 11:50 AM