Solved

Cognos 8.3 calculations on total lines

Posted on 2011-03-16
4
525 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
I need an assist with a programming logic math question. 5 87
Run AutoHotkey script directly from Notepad++ 5 130
Why use this lambda? 12 60
Is online banking safe? 11 81
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this post we will learn different types of Android Layout and some basics of an Android App.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

735 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