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).

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

Can this be done in BIRT?
Previous Topic:Error.... help me
Next Topic:Master Page or(page orientation) Based on the parameter
Goto Forum:

Current Time: Sun Sep 20 09:19:38 GMT 2020

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

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

Back to the top