Eclipse Community Forums: BIRT » Calculate Cumulative value in cross tab

Home » Archived » BIRT » Calculate Cumulative value in cross tab(Calculate Cumulative value in cross tab)

Calculate Cumulative value in cross tab [message #708016]

Tue, 02 August 2011 06:38

Eclipse User

Hi Jason,

I want to generate a report with cumulative.

I am creating the report using Cross tab.

The report is like,

jan || Feb || Mar
1 || 2 || 3

1 is the value of Jan and 2 is the value of Feb and 3 is the value of Mar.

for Jan, the value is same.
For Feb, The report should calculate jan+ Fab

i.e

Jan || Feb || Mar
1||3||6

Plz help me on this.

Re: Calculate Cumulative value in cross tab [message #708253 is a reply to message #708016]

Tue, 02 August 2011 11:29

Eclipse User

On the aggregation element in the crosstab put an oncreate script like:

//This is summing integers, you can also use parseFloat
if( typeof myrunningsum != 'undefined'){
myrunningsum = parseInt(this.getValue()) + parseInt(myrunningsum);
}else{
myrunningsum = parseInt(this.getValue());
}
this.setDisplayValue(myrunningsum);

See attached example

Jason

On 8/2/2011 6:38 AM, jeyinul wrote:
> Hi Jason,
>
>
> I want to generate a report with cumulative.
>
> I am creating the report using Cross tab.
>
> The report is like,
>
> jan || Feb || Mar 1 || 2 || 3
>
> 1 is the value of Jan and 2 is the value of Feb and 3 is the value of Mar.
>
> for Jan, the value is same.
> For Feb, The report should calculate jan+ Fab
>
> i.e
>
> Jan || Feb || Mar
> 1||3||6
>
> Plz help me on this.

Attachment: staticdimrunningsum.zip
(Size: 2.26KB, Downloaded 266 times)

Re: Calculate Cumulative value in cross tab [message #708702 is a reply to message #708253]

Wed, 03 August 2011 01:19

Eclipse User

Its not working Jason,

I am getting like NaN in each column.

Re: Calculate Cumulative value in cross tab [message #709164 is a reply to message #708702]

Wed, 03 August 2011 11:16

Eclipse User

What is the data type of the element and what version of BIRT are you using.

Jason

On 8/3/2011 1:19 AM, jeyinul wrote:
> Its not working Jason,
>
> I am getting like NaN in each column.
>
>

Re: Calculate Cumulative value in cross tab [message #1800548 is a reply to message #709164]

Wed, 02 January 2019 03:44

Eclipse User

I also getting the NaN on every column. My data type is Integer and using Version: Kepler Service Release 1

Previous Topic:	DataException: The new column name or alias...
Next Topic:	org.eclipse.birt.report.engine.api.EngineException: Can not convert the value of 17-12-2018 to java.

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 16:39:10 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter