Rangemax second greatest value

DaanBrand — Mon, 24 Jul 2017 12:25:27 GMT

Hi,

I have a question about the rangemax function.

I want to create a rolling average over 10 week excluding the two min- and max values over this 10 week.

I made it to find the max value with the rangemax function:

Rangeavg(above(sum(aggr(sum(Omzet.Gewicht),ArtID,WeekYear)),1,10))

But is it possible to get the second greatest value? With something like the Max(value, 2) function?

Thanks in advance.

Daan

Re: Rangemax second greatest value

antoniotiman — Mon, 24 Jul 2017 16:34:38 GMT

Hi Daan,

try this

Max(Aggr(If(Rank(Sum(Omzet.Gewicht)) > 1 and Rank(-Sum(Omzet.Gewicht)) > 1,Sum(Omzet.Gewicht)),ArtID,WeekYear))

Regards,

Antonio