Cognos 8.3 calculations on total lines

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?
pwigintonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SNeupaneConnect With a Mentor Commented:
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
 
SNeupaneCommented:
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
 
pwigintonAuthor Commented:
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
 
pwigintonAuthor Commented:
You got me on the right track. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.