COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: morphy on 13 Nov 2008 05:09:20 AM

Title: Syntax of summary functions
Post by: morphy on 13 Nov 2008 05:09:20 AM
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
Title: Re: Syntax of summary functions
Post by: Suraj on 14 Nov 2008 11:41:38 AM
total (hours) for report

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