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 in changing calculation of List Summary cell.

Started by KEKeogh, 13 Mar 2009 04:49:28 PM

Previous topic - Next topic

KEKeogh

Help! 

I know this has to be simple.  This is what I have so far in Cognos 8.3 Report Sudio.

COMPUTING_TYPE     Unweighted Availability         Multiplier         Availability         APPLICATION_NAME
Online                                100.00%                      3.47%             3.47%             Application 1
Online                                96.01%                        7.99%             7.67%             Application 2
Online                                100.00%                     10.07%            10.07%            Application 3
Online                                99.95%                       11.46%            11.45%            Application 4
Online                                100.00%                     10.42%            10.42%            Application 5
Online                                100.00%                      7.29%             7.29%             Application 6
Online                                100.00%                      7.29%             7.29%             Application 7
Online                                100.00%                      5.21%             5.21%             Application 8
Online                                100.00%                      9.72%             9.72%             Application 9
                                                                                      Total Availability Column
                                                                                                 72.59%


What I'm looking to do is add 27.08% to the List Summary Cell of the Availability column to get 99.67% (ie 72.59% + 27.08%).

Right now it's formula is Total[Availability] with the Aggregate Function "Calculated" and Rollup Aggregate Function "Total".

I've tried changing the aggregates but keep getting wierd numbers each time.  Am I doing something wrong?

Thanks
Kathie

Gollapudi

Hi,

Just wanna have more clarity on this, where did you get this value form[27.08%], you wanna hardcode it or is there any reason to add this, any ways if you wanna change the List summary just unlock your report and have a Query Calculation there which will get the same value then you can do what ever manipulations you want....  the default summary field will use the same data item which is in detailed level, so what ever changes you do at summary level will applies to detailed level tooo.. thats why its better to have a query calculation when you need some manipulations...

Thanks,
Gollapudi.

KEKeogh

The 27.08% is missing data that has yet to be created.

We want to report the number and have it look somewhat normal. 

As it stands our applications would look like they were only 72.59% available but with the missing apps it would actually be 99.67% availabilie, which is what we would like to see.

So we want to add that missing data to the current total.

Gollapudi

Hi,

That case adding a query calculation can help you....

Thanks,
Gollapudi.

JGirl

You could create a line for the missing application by using a union query.

Query a = Actual results from the database
Query B = Dummy results for the missing app (you'd need to include at least one database column for this to work)

Query C = union of Query A & Query B

This way you wouldnt need to adjust the aggregation values - rather you could just aggregate normally.


KEKeogh

Thanks! 

My boss actually came over and came up with another temporary solution. 

Instead of adding the total 27.08% to the formula of the list summary cell, we had to divide 27.08% by 9 (the # of current apps) and use that in the formula.

So it wound up being [Availability]+(.2708/9), then it gave me the right numbers.  Better solution for a temporary fix. 

Can't wait until those other apps are setup.

Kathie