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 14: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 12: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 82 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 Aug 30 20:37:36 EDT 2014

Powered by FUDForum. Page generated in 0.07289 seconds