Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Format Number on Table
Format Number on Table [message #368357] Mon, 25 May 2009 08:50 Go to next message
tero  is currently offline tero Friend
Messages: 58
Registered: July 2009
Member
Hello All,

While trying to format a number in a table to "Percent", I see a strange
behaviour:
Having to display a float, even the preview is displaying for 1,234.56:
123456.00% if I select 2 Decimal places!

Souldn't that be something like 1,234.56% ? That is what I would like to
have. A solution would be to format it "fixed" and add the "%" manually,
but that's a workaround...

Thanks,
Tero
Re: Format Number on Table [message #368372 is a reply to message #368357] Tue, 26 May 2009 15:17 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Tero,

You can also modify the expression for the actual value like:

dataSetRow["mypercentvalue"]/100

Jason

Tero wrote:
> Hello All,
>
> While trying to format a number in a table to "Percent", I see a strange
> behaviour:
> Having to display a float, even the preview is displaying for 1,234.56:
> 123456.00% if I select 2 Decimal places!
>
> Souldn't that be something like 1,234.56% ? That is what I would like to
> have. A solution would be to format it "fixed" and add the "%" manually,
> but that's a workaround...
>
> Thanks,
> Tero
>
Re: Format Number on Table [message #368415 is a reply to message #368372] Thu, 28 May 2009 09:31 Go to previous messageGo to next message
tero  is currently offline tero Friend
Messages: 58
Registered: July 2009
Member
Hello Jason,

Thanks for your answer.

That would be a workaround too.
Is the "Percent" format not meant to deal with float?

What if in a future Birt release, it displays the correct way?

Is there a reason why the number 1,234.56 is displayed 123456.00% when
formatted as "Percent" ?

Thanks,
Tero
Re: Format Number on Table [message #368422 is a reply to message #368415] Thu, 28 May 2009 15:20 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Tero,

Did you log a bug for this?

Jason

tero wrote:
> Hello Jason,
>
> Thanks for your answer.
>
> That would be a workaround too. Is the "Percent" format not meant to
> deal with float?
>
> What if in a future Birt release, it displays the correct way?
>
> Is there a reason why the number 1,234.56 is displayed 123456.00% when
> formatted as "Percent" ?
>
> Thanks,
> Tero
>
Re: Format Number on Table [message #368424 is a reply to message #368422] Thu, 28 May 2009 15:49 Go to previous message
tero  is currently offline tero Friend
Messages: 58
Registered: July 2009
Member
https://bugs.eclipse.org/bugs/show_bug.cgi?id=278244
Previous Topic:how to handle multiple parms in query
Next Topic:Problems with DATASETS - Urgent :/
Goto Forum:
  


Current Time: Thu Sep 26 17:09:23 GMT 2024

Powered by FUDForum. Page generated in 1.04163 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top