Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cognos 8.3 calculations on total lines

Posted on 2011-03-16
4
Medium Priority
?
544 Views
Last Modified: 2012-08-13
I have a report that has footer totals for 3 groups.  On each of those total lines, using items from the total lines, I want to do a query calculation.  When I do I get only zero for a result.  How should calculations be done on footer lines?
0
Comment
Question by:pwiginton
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:SNeupane
ID: 35150034
It'll be easier if you unlock the report, click on the total data item one by one and delete them.
Then add a new query item inside each cell with the calculation you want that's independent of the auto summarized calculations.
0
 

Author Comment

by:pwiginton
ID: 35152490
Is that the only way?  Is it possible to use the calculation with some type of For statement and get the same result?

With the solution you suggest, what would that calculation look like?  I have 3 detailed columns (Book Value, Units and Weighted Index) that are subtotaled at 3 group levels, the lowest called Speed_Change, the next highest group Discount-Par and the highest group Issue Type.

My calculation is Round(Weighted Index / (Total of Units - Total of Book Value), 2)
0
 
LVL 8

Accepted Solution

by:
SNeupane earned 1000 total points
ID: 35152582
There is always more than one way to solve but one may be easier than other.
Anyways, for your calculations, use for after the totals.
For example:
round(
total([Weighted Index] for report or use a grouping level)
/
(total([Units] for report or use a grouping level)-total([Book Value] for report or a grouping level))
)
It should work if you play with the for part since you have to give proper group level to total depending on what data you need.
0
 

Author Comment

by:pwiginton
ID: 35179601
You got me on the right track. Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Simple Linear Regression
Loops Section Overview

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question