Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » First Report - How to multiply a dataset field by 100 and round?
First Report - How to multiply a dataset field by 100 and round? [message #804565] Wed, 22 February 2012 19:35 Go to next message
Birt Unmitigated is currently offline Birt Unmitigated
Messages: 14
Registered: February 2012
Junior Member
Say I have a dataset with 3 fields: A, B, and C.

C contains decimal numbers. On the report I want to display C multiplied by 100 and rounded.

Is this possible? How would I do it?

Thanks,

B
Re: First Report - How to multiply a dataset field by 100 and round? [message #805371 is a reply to message #804565] Thu, 23 February 2012 17:25 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Sure this can be done by entering an expression similar to the following:
BirtMath.round(row["QUANTITYORDERED"]*100)

See attached example.

Jason

On 2/22/2012 2:35 PM, Birt Unmitigated wrote:
> Say I have a dataset with 3 fields: A, B, and C.
>
> C contains decimal numbers. On the report I want to display C multiplied
> by 100 and rounded.
>
> Is this possible? How would I do it?
>
> Thanks,
>
> B
  • Attachment: round.zip
    (Size: 1.79KB, Downloaded 85 times)
Previous Topic:Really confused by data bindings
Next Topic:Can't format default date parameter as yyyy-MM-dd
Goto Forum:
  


Current Time: Sat Oct 25 10:15:55 GMT 2014

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

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