?
Solved

Cognos 8.3 calculations on total lines

Posted on 2011-03-16
4
Medium Priority
?
546 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Simple Linear Regression
Starting up a Project

621 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