Calculate TOTAL Column

[Sarebok]

Hi, at first sorry for my english.

I have a question about sumatorize data columns.

I have this data:



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.

[BigChris]

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

[Sarebok]

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

Thanks for all!!

[BigChris]

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.

[sunny bachan prasad]

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

:)