Print Page - Percentage of Base with Report Studio

Title: Percentage of Base with Report Studio
Post by: skocet on 28 May 2010 06:47:39 AM

Hi all,

I'm working on a financial report (Report Studio 8.3) with a MDC cube as datasource.
I want to display a list of accounts, for each account an amount and into a third column, a percentage of my amount based on a specific account :

Account | Amount | %Amount
-----------------------------
A1 | 100 | 50%
A2 | 200 | 100% <- This account must be concidered as the base of my percentage
A3 | 50 | 25%
A4 | 40 | 20%
A5 | 20 | 10%

Any ideas ?

Thank's in advance

Regards

SK

Title: Re: Percentage of Base with Report Studio
Post by: colt on 28 May 2010 07:17:09 AM

[%Amount]=[Amount]/total([Amount] within set [A2]) should work

Title: Re: Percentage of Base with Report Studio
Post by: skocet on 28 May 2010 07:41:47 AM

Fine colt, it's OK

Thank's a lot

Bye

SK

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: skocet on 28 May 2010 06:47:39 AM