Solved

Cognos 8.3 calculations on total lines

Posted on 2011-03-16
4
528 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 250 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this post we will learn different types of Android Layout and some basics of an Android App.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

752 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