INTERACT FORUM

More => Old Versions => JRiver Media Center 18 for Windows => Topic started by: mark_h on April 15, 2013, 07:22:36 am

Title: Formatting numbers to two decimal places WITH zeros?
Post by: mark_h on April 15, 2013, 07:22:36 am

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??

Title: Re: Formatting numbers to two decimal places WITH zeros?
Post by: vagskal on April 15, 2013, 11:47:25 am

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 ".".)

Title: Re: Formatting numbers to two decimal places WITH zeros?
Post by: mark_h on April 16, 2013, 01:39:57 am

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.

Title: Re: Formatting numbers to two decimal places WITH zeros?
Post by: MrC on April 16, 2013, 02:44:29 am

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 (http://yabb.jriver.com/interact/index.php?topic=69377.msg467279#msg467279)

Title: Re: Formatting numbers to two decimal places WITH zeros?
Post by: vagskal on April 16, 2013, 02:48:46 am

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

Title: Re: Formatting numbers to two decimal places WITH zeros?
Post by: MrC on April 16, 2013, 03:00:41 am

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