Eclipse Community Forums: BIRT » Column sum based on another column

Help

Home

Home » Eclipse Projects » BIRT » Column sum based on another column

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

Column sum based on another column [message #770678]

Sat, 24 December 2011 20:52

Nagabhushan Bhushan is currently offline

Nagabhushan Bhushan
Messages: 2
Registered: December 2011

Junior Member

Hi,

I'm new to BIRT and am trying to create a balance sheet report which contains amount column and DB/CR column.
I need to calculate sum of Amount column based on DB/CR. i.e., i need to ADD the amount value if DB/CR column has DB and subtract amount value if DB/CR has CR.
the total has to be displayed at the end of the amount column.
Please help how to calculate the same

Attachment: For example.docx
(Size: 13.01KB, Downloaded 71 times)

Report message to a moderator

Re: Column sum based on another column [message #771600 is a reply to message #770678]

Tue, 27 December 2011 13:07

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

How do your DB/CR values come in? As positive and negative values?
Can you post a sample of what the data could look like?

Jason

On 12/24/2011 8:52 PM, Nagabhushan Bhushan wrote:
> Hi,
>
> I'm new to BIRT and am trying to create a balance sheet report which contains amount column and DB/CR column.
> I need to calculate sum of Amount column based on DB/CR. i.e., i need to ADD the amount value if DB/CR column has DB and subtract amount value if DB/CR has CR.
> the total has to be displayed at the end of the amount column.
> Please help how to calculate the same
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Column sum based on another column [message #771655 is a reply to message #771600]

Tue, 27 December 2011 16:09

Nagabhushan Bhushan
Messages: 2
Registered: December 2011

Junior Member

I've attached the sample of how the report should look like. I need to get the value of TOTAL that is calculated in the sample data.
The table is grouped based on the GLType and Ledger number and for each group of gltype, i need to display the total.

Attachment: Book1.xlsx
(Size: 10.14KB, Downloaded 59 times)

Report message to a moderator

Re: Column sum based on another column [message #772433 is a reply to message #771655]

Thu, 29 December 2011 14:24

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

I am not sure how you calculate your balance, but I dumped your data to
csv file and wrote a report off of it. If you look at the expression on
the aggregation element in the group footer you will see how I handle
the db vs cr field.

if(dataSetRow["DB / CR"] == "db"){
dataSetRow["Balance"];
}else{
dataSetRow["Balance"]*-1;
}

Jason

n 12/27/2011 4:09 PM, Nagabhushan Bhushan wrote:
> I've attached the sample of how the report should look like. I need to get the value of TOTAL that is calculated in the sample data.
> The table is grouped based on the GLType and Ledger number and for each group of gltype, i need to display the total.

Attachment: ledgerexample.zip
(Size: 3.01KB, Downloaded 64 times)

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Report parameters not retaining default value
Next Topic:	How to calculate SUM cumulative times type of string?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 08:05:45 EDT 2013