|
Re: Calculate Cumulative value in cross tab [message #708253 is a reply to message #708016] |
Tue, 02 August 2011 15:29 |
|
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.
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.01916 seconds