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

Syntax of summary functions

Started by morphy, 13 Nov 2008 05:09:20 AM

Previous topic - Next topic

morphy

Hi All,

I am trying to calculate the Total Hours for each Organization using
the Summary Functions.

I wrote in the Data Item:

total [HOURS] for [ORGANIZATION]

and it works!
In fact I obtained a report like this one below:

ORGANIZATION    HOURS
------------------------
    ITALY                5
   FRANCE               4
     USA                  7

Now using the Summary Function I wanna obtain the Total Hours (5 + 4 +7). What do I have to write?

Is it ok if i do:

total [HOURS] for ALL [ORGANIZATION]

???

Please help me.

Have a great day and thanks in advance.

Matt

Suraj

total (hours) for report

or
just click on aggregate on the Hours column and u'll get total row.