If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with Totaling!

Started by movieposters, 11 Apr 2024 02:40:59 PM

Previous topic - Next topic

movieposters

Hi all...want to run this by you with hope for an easy solution I'm overlooking. 

This is the output of a summary report.  All is perfect, except for when it 'averages the average columns' (shown in red on cells I7 and I15)   

Like the columns prior that make up this total, this total column amount should simply divide column H by column C instead of averaging.

How can I simply have this total reflect an amount equal to dividing total line (H7 by C7)?

cognostechie

Hi

You can unlock the report, remove the total and add another data item with something like this:

total([Current Amount Excluding Bonus] ) / total([Current Hours]) for [Department]

By the way, are you posting your actual data here? Your managers may not be too happy to see this

movieposters

Quote from: cognostechie on 11 Apr 2024 05:30:14 PMHi

You can unlock the report, remove the total and add another data item with something like this:

total([Current Amount Excluding Bonus] ) / total([Current Hours]) for [Department]

By the way, are you posting your actual data here? Your managers may not be too happy to see this

Thanks...and never, it's a sandbox environment : )