Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mark_h]

FormatNumber() allows us to specify the number of decimal places but it seems to truncate ZEROS from the display,

eg displaying

2.2

instead of

2.20

Any way around this??

[vagskal]

It is ugly:

if(isequal(length(listitem(formatnumber(2.201,2),1,/,)),2,4),formatnumber(2.201,2)0,formatnumber(2.201,2))

(In my locale comma is used as the decimal point, so you might want to change "/," to ".".)

[mark_h]

Very close but I'm getting integer numbers, eg 2, coming out as 20

It's a shame format number doesn't do the padding.

[MrC]

I agree - FormatNumber() should do what it is asked, since its purpose is to format a number.

Here's another option:

   regex(0[your field], /#^(\d+)?(?:\.(\d+))?#/, -1)formatnumber([R1],0).left([R2]000000000,2)

It doesn't deal with empty values (turns them into 0.00).  Change the red value to the number of decimal places you want.

See also:

    http://yabb.jriver.com/interact/index.php?topic=69377.msg467279#msg467279

[vagskal]

Thanks, MrC. I obviously did not get it right.

[MrC]

Your method works with a listcount() == 2.