Sum of calculated key figures in a report

[Former Member]

Hi,

i have the following report :

Country percent

FR 0%

SP 100%

GE 100%

UK 100%

I want to display at end a line with : sum percent / number of country

The result should be : 300/4 = 75%

but my result is 60 / 4 = 15%

( value 60 corresponding at percent calculated for all the country

- formul to calculate percent for one country is applicated for all the country in global).

Version 3.1

Any suggestion is highly appreciated.

Thanks in advance.

JC.

[ChandranGanesan]

Hello JCA,

Create a Formula or CKF like this (FR + SP + GE + UK) / 4. This will give you the average of these four keyfigures.

In the Column it will be like this

FR

SP

GE

UK

CKF/Formula containing the above

Thanks

Chandran

[Former Member]

Hello,

I can't , because value for FR,SP ... is a calculated value.

The result for ( FR+ SPGEUK / 4) give a bad value (60%) .

Regards.

JCA