Find Average ,5

[CreoLTD112]

Hey all..

Still new around here, quick question..

I have a straight table with several fund amount values e.g:

123349.67

4656457.12

67585.77

78768578.66 etc…

I need to do the following:

Get the average 5 only - i would like to do this as a math equation if it is possible but any fix would be appreciated,

The current list of amounts are 50+ amounts,

Can someone assist please

Thanks

[jonathandienst]

>>Get the average 5 only

What does that mean? Please provide more detail about your requirements, preferably with some sample date and expected output. That way you are more likely to get helpful suggestions.

[CreoLTD112]

Hi

Sure,

Please see attached where one side has the user and other is the amount connected to the user,

Now I want the 5 average user’s in terms of values

Same as how one would ge the 5 highest/lowest values - I need the 5 average values

Hope this helps..

Thanks

[sunny_talwar]

Based on the sample provided, would you be able to provide the expected output in an Excel file?

[CreoLTD112]

Please find attached

So I need the 5 average amounts per user,

e.g: I have 54 users so my average amount should be the 27th user = PersonZ

So I need the 2 people and their total above PersonZ and below PersonZ

 hope this helps

[CreoLTD112]

However i want to do this as an expression 

my result should look like this:

user25	50,107.03
user26	57,854.97
Personz	79,502.52
user28	80,770.99
user29	119,377.60

[sunny_talwar]

This makes sense now, but before I answer, is amount a field or a calculation in the chart that you have shared? If it is a calculation, can you let us know what the expression for amount is?

[CreoLTD112]

Hi yes it is

=sum(Fund_Amount_Dec)-sum(Fund_Amount_Nov)

In order to get the difference between the two months now I want the 5 average amounts of that