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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / sivas

If you want see the day wise total that situation use
running total function.

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Cognos Interview Questions

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,


----------------Diff b/w Dimensional modeling and Relational modeling?

3 Answers   Cap Gemini, L&T,


How do we create row level security in cognos8?

3 Answers  


how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

1 Answers  


how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  


hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

1 Answers   HCL,


Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....

2 Answers  


How do you improve the performance of the Cognos Analytics report

1 Answers  


What is Correlated sub-query? Please explain

1 Answers   Target,


What are all the advantages of Cognos?

1 Answers  


whis meant by Thumbnails on cagnos?

2 Answers  


Categories