Average below and above

[#1]

I need to calculate the average of the 10 entries below and above of a field in the script

[Jason_Michaelides]

In your chart try this expression:

RangeAvg(Above(Sum(YourField),10,20))

Hope this helps,

Jason

[Jason_Michaelides]

PS you might need -10 as the second parameter for Above(). I can't remember if the offset goes up or down...

[#4]

Thanks

[#5]

Thanks...

If I can not find how to do it in the script, I will do in the graph as you show me

[#6]

Thanks...

If I can not find how to do it in the script, I will do in the graph as you show me

[Jason_Michaelides]

If you need to do it in the script look at using Peek()