Print Page - Calculate TOTAL Column

Title: Calculate TOTAL Column
Post by: Sarebok on 13 Jan 2015 04:35:11 AM

Hi, at first sorry for my english.

I have a question about sumatorize data columns.

I have this data:

(http://i.imgur.com/SKO5bCB.jpg)

and i want a new column with the total of the all datas, in this table will be (10+11+39= 60).

I want this column because i want calculate the % in each column over the total of the columns.

Thanks for all.

Title: Re: Calculate TOTAL Column
Post by: BigChris on 13 Jan 2015 07:54:16 AM

You probably want something along the lines of: Total([AC_ACCOUNT_ID] for report)

Title: Re: Calculate TOTAL Column
Post by: Sarebok on 13 Jan 2015 07:59:43 AM

Okey!! i don't know how can i use the statement "for" in Cognos Queries.

Thanks for all!!

Title: Re: Calculate TOTAL Column
Post by: BigChris on 13 Jan 2015 08:05:09 AM

In your Query drag in a new Data Item. You can then build the function that you need. Once you've done that you can add the field (data item) to your list.

Title: Re: Calculate TOTAL Column
Post by: sunny bachan prasad on 13 Jan 2015 09:19:45 AM

Hi Sarebok,
You can refer below mention link to know how to use the "for" statement in Cognos Queries

http://www.itap.purdue.edu/ea/files/understandingthecognossummaryfunctions.pdf

:)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Sarebok on 13 Jan 2015 04:35:11 AM