Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Sum All Rows based on Value of Field(Sum All Rows based on Value of Field)
Sum All Rows based on Value of Field [message #1802225] Mon, 04 February 2019 16:36
Aaron Stetts is currently offline Aaron StettsFriend
Messages: 1
Registered: February 2019
Junior Member
I am trying to sum all values of a specific field (AMOUNT) based on the values of a second field in each row (PRIORITY). I need to sum all AMOUNT values where the PRIORITY of each row is less than the PRIORITY of the output row.

Table example below with the expected output. This is pretty simple to do in Excel, SQL, etc., but I cannot figure out how to do this in BIRT (I am new).

PRIORITY AMOUNT Output
1 100 0
2 50 100
3 75 150
4 25 225
5 10 250

Can this be done in BIRT?
Previous Topic:more than 70000 rows reports not working
Next Topic:Error.... help me
Goto Forum:
  


Current Time: Wed Jul 24 02:34:07 GMT 2019

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

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

Back to the top