topic Re: Find Average ,5 in Water Cooler

Find Average ,5

CreoLTD112 — Tue, 15 Jan 2019 06:07:01 GMT

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

Re: Find Average ,5

jonathandienst — Tue, 15 Jan 2019 06:20:06 GMT

>>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.

Re: Find Average ,5

CreoLTD112 — Tue, 15 Jan 2019 07:10:25 GMT

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

Re: Find Average ,5

sunny_talwar — Tue, 15 Jan 2019 12:29:46 GMT

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

Re: Find Average ,5

CreoLTD112 — Wed, 16 Jan 2019 09:56:30 GMT

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

Re: Find Average ,5

CreoLTD112 — Wed, 16 Jan 2019 09:56:01 GMT

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

Re: Find Average ,5

sunny_talwar — Wed, 16 Jan 2019 12:10:33 GMT

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?

Re: Find Average ,5

CreoLTD112 — Wed, 16 Jan 2019 12:24:47 GMT

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