I'm tying myself in knots trying to write a formula. I'll try to explain.
I have formula that counts the number of days between two events on tickets. This is used in the report so it looks like:
Ticket1 45
Tic ket2 07
Tic ket3 145
Ticket4 23
Ticket5 62
etc (There will normally be a minumum of about 30 tickets.
What I want to do is disregard the best 10% and the worst 10% then do an average on the rest. So, in the case of the above, 07 and 145 would be disregarded and the remaining values would be averaged (43.33). Of course, depending on the number of values returned it isn't always going to be 1 of the top and the bottom. It needs to be 1 or 10% whichever is higher.
Any help appreciated.