can anybody tell me when do use 'running total'...give an
example for the usage of running total

Answer Posted / thanjairajan@gmail.com

Returns a running total by row (including the current row) for a set of values

*For example if our list container contain order no,product name,quantity
*Then we drag query calculation
*Then we give name for new column. that name is Total.
*In expression definition window drag running-total function from summaries function of left side available components.
*If we want ruuning-total for quantity,drag quantity data item within running-total function. like running-total(quantity).
*Finally in report output in total column the first quantity value will display in first row of total column, in second row of total column add first quantity and current row quantity, in third row of total column add first,second and current row quantity.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Additive function?

1782


Explain informatica architecture?

769


what is the difference between querystudio in reportnet and cognos8

1954


Can you define transformer?

742


Define olap designer?

925


What are the components of the report studio?

918


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2535


What is model filter?

849


Can you define dimension?

880


What are initial page components of Cognos connection?

822


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2200


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1790


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1907


Explain the characteristics of cognos?

807


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1723