Eclipse Community Forums: BIRT » First Report - How to multiply a dataset field by 100 and round?

Help

Home

Home » Eclipse Projects » BIRT » First Report - How to multiply a dataset field by 100 and round?

Show: Today's Messages :: Show Polls :: Message Navigator

First Report - How to multiply a dataset field by 100 and round? [message #804565]

Wed, 22 February 2012 14:35

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

Report message to a moderator

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

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 54 times)

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Really confused by data bindings
Next Topic:	Can't format default date parameter as yyyy-MM-dd

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 08:23:40 EDT 2013