Skip to Content
0
Former Member
Oct 01, 2007 at 09:07 PM

How to calculate correct percentage for a formula

20 Views

Hi Experts,

I have KeyFigures A and B. Example below.

Formula, C = A*B.

Overall Result for C, is acheived by calculating result as 'Summation'.

Formula, D = %CT (A*B)

Overall Result for D is 100%.

I would like the percentages for D in the below example to be (8/11)% instead of (8/21)% and (3/11)% instead of (3/21)%.

Eg:

A--


B
C
--


D

2______4______8______(8/21)%

1______3______3______(3/21)%

-


3--


7
11

(100%) <
---Overall Results

-


( BTW, I have been trying %GT, %CT, ...SUMGT,...... Also, tried D>properties>Formula Collission> Result From This Formula )

Please let me know how can I get the correct percentages for D.