Average if and fractile

[#1]

Hi

I would like to take the average of the lowest 90% of Dage - I imagine something like this - but I am doing something wrong -can you help me, please 🙂

=Avg({< Dage = {"<"&Fractile(Dage,0.90)} >} Dage)

[sunny_talwar · Accepted solution]

May be try this

=Avg({<Dage = {"$(='<' & Fractile(Dage,0.90))"}>} Dage)

or

=Avg({<Dage = {"<$(=Fractile(Dage,0.90))"}>} Dage)

[hemachandran]

try this expression

=Avg({<Dage = {"$(='<' & Fractile(Dage,0.90))"}>} Dage)

[#4]

Perfect - the first one did it 🙂

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

Please never flag your own posts as Helpful or Correct.

I have removed the "helpful" flag from your own post.

[#6]

Sorry - I must be absolutely blind I cannot see the big "Answer correct" button - se attached screen dump

[oknotsen]

Ah, you are not opening the actual topic but are replying to it from elsewhere (I think your inbox?). For some reason it does not show those big buttons in that case.

If you click on the topic title (so "Average if and fractile" in your case), it will open a new page with the topic (which also will show you all replies instead of just a selected few). You should now see the button.

[#8]

Thanks - now I got it 🙂

[oknotsen]

Happy I could help