calculate the mean of an account

[Former Member]

hello friends

i have a dimension account in which one particular account which gives me problem

imagine you have an acocount A

you have an input scedule where you write in

2007.MAR Account A Entity E1 value 30

2007.JUN Account A Entity E1 value 60

when you look in a report the agregated value on time dimension on 2007, you don't add the 2 values, but you nead the mean ( 30+60)/2

actually, whenever you want to see an agregated value on any dimension, for this special account, you don't add the values but calculate the mean

how can i do that, except of using formula column in every dimension sheet which will make things more difficult i feel

please tell me if the question isn't clear

thanks in advance for guidance about this problem

regars

CL

[Former Member · Accepted solution]

The 3 options that I can think of are:

- Create the mean in Excel for the account, since the entered data must be stored

- Create a new account called AccountA_Mean, and apply dimension logic to the AccountA values but report them in this account.

- Build a new Measure against which all accounts will nbe applied to get mean values.

Each has pros-cons for user acceptablility, performance and functionality. One easy thing to use is the EVDREE SUBTOTAL function in the SORT After range, which allows you to use the standard Excel functions to developa mean value for a given set.

Hope this helps.

[Former Member · Accepted solution]

thanks for your guidance sir

i will evaluate the impact of each solution and choose the one easier in terms of implemetation for me at first place; thanks for giving me these options

regards

CL

[Former Member · Accepted solution]

Hi Petar,

How is a new measure built?

Cheers