Eclipse Community Forums: BIRT » Operation between two row

Search

Help

Login

Home » Archived » BIRT » Operation between two row

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

Operation between two row [message #1695320]

Wed, 13 May 2015 13:20

Massimilino Oreto is currently offline

Massimilino Oreto

Friend

Messages: 6
Registered: February 2014

Junior Member

Hi people, i need help in a Birt operation.

I have a dataset with montly turnover divided by year.

For example i have

year Total Gen Feb Mar
2015 100 20 10 xxxxxx
2014 80 15 18 xxxxx

What i need is a new column that permit me to make the year difference. For example , a new column that have 20-15 end the value.

So a column that take the current row and make operation with other row.

Thank you for help

Report message to a moderator

Re: Operation between two row [message #1695473 is a reply to message #1695320]

Fri, 15 May 2015 04:12

Michael Williams is currently offline

Michael Williams

Friend

Messages: 1925
Registered: July 2009

Senior Member

mwilliams.silanis

So, you'd want:

year Total Gen Feb Mar
2015 100 20 10 xxxxxx
2014 80 15 18 xxxxxx
Diff 20 5 -8 xxxxxx

Or actually new columns?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Operation between two row [message #1695480 is a reply to message #1695473]

Fri, 15 May 2015 07:28

Massimilino Oreto is currently offline

Massimilino Oreto

Friend

Messages: 6
Registered: February 2014

Junior Member

No, i need on a new column on the same row.
Thanks for help

Report message to a moderator

Re: Operation between two row [message #1695611 is a reply to message #1695480]

Mon, 18 May 2015 05:54

Stefan Seitz is currently offline

Friend

Messages: 14
Registered: February 2015

Junior Member

You could add another column to your dataset which has the last year's values. From that you could calculate the difference

Report message to a moderator

Re: Operation between two row [message #1695615 is a reply to message #1695611]

Mon, 18 May 2015 07:15

Massimilino Oreto is currently offline

Massimilino Oreto

Friend

Messages: 6
Registered: February 2014

Junior Member

Yes, i have a dataset with this data but i hope that with the power of birth ther's another possibilities (lighter)

Thank you for reply

Report message to a moderator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	Embedded report in plugin, where's the JavaScript function?
Next Topic:	Can't set a font typeface for the Body of a report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:11:30 GMT 2024

Powered by FUDForum. Page generated in 0.03107 seconds

.:: Contact :: Home ::.

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

Back to the top