Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Aggregation BIRT(Aggregation)

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

Aggregation BIRT [message #1403433]

Wed, 23 July 2014 16:08

Daniel Hudson

Messages: 7
Registered: July 2014

Junior Member

Hello all,
I have just about finished off a report using BIRT and I'm looking for some assistance using aggregation. If you look at the attached file the last two columns named unit price and quantity are the two I am wanting to work with. I need to SUM all the data in the quantity column to get a total. Then, Divide each rows unit price into the quantity on the same row to end up with a Total Value £, then I need to get the average unit price based on these totals. TOTAL VALUE divided into TOTAL QUANTITY to gain the average Unit Price.

Sorry If I haven't been clear enough, please ask if you need any more info.

Appreciate your help.

Thanks.

Attachment: EG BIRT REP.docx
(Size: 184.39KB, Downloaded 154 times)

Report message to a moderator

Re: Aggregation BIRT [message #1407041 is a reply to message #1403433]

Mon, 11 August 2014 18:43

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Could you include a table of data with the calculations done how you'd like them? Just an Excel file will work. I just want to see everything you're wanting. Thanks.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	How to print the same dynamic image on every page.
Next Topic:	Parameterize the Order By Clause?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:24:01 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter