Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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:Error.... help me
Next Topic:Master Page or(page orientation) Based on the parameter
Goto Forum:
  


Current Time: Tue Mar 19 09:21:15 GMT 2024

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

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

Back to the top