Print Page - Summing the % values

Title: Summing the % values
Post by: k2 on 05 Jun 2008 05:41:18 AM

I am having a % field when I aggregates it, am getting the total value of the percentage say 70%+30%+50% = 150% but not the actual SUM % of the field. Could any one help me out.
Thanks in Advance.

Title: Re: Summing the % values
Post by: jdaems on 09 Jun 2008 06:20:00 AM

What kind of rollup have you used for this measure? Check if you have used before rollup or after rollup for the measure?

Title: Re: Summing the % values
Post by: k2 on 23 Jun 2008 10:05:10 AM

Thanks for the reply, i have sorted out that issue.

[Quantity] / total([Quantity] within set [Month],[Area])

The above thing will display the 100% Total of Quantity sold with respect to Month & Area of sales.

Title: Re: Summing the % values
Post by: SanderH on 25 Feb 2009 02:25:23 AM

I need this total function as well to calculate the Marketshare %:

e.g.:
(Quantity / total(Quantity] within set [Competitors])

But the total function it is not available in the functions when I add a calculated measure.

Any idea why?

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: k2 on 05 Jun 2008 05:41:18 AM