Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I try to eval the minimum value in a dimension above a given threshold
aggr (min ( if (bincount > 7 , bincount) ), dim )
which works fine for e.g.
dim=1, (ordered) values=3,1,4,8,5,1 evals to 8dim=1, (ordered) values=7,18,1,5,1 evals to 18
Instead of bincount I however need the accumulated bincount value. If I use
if (rangesum(above(bincount,0,rowno())) > 7, bincount)
I get the correct values displayed in my straight table expression column
dim=1, (ordered) values=3,1,4,8,5,1 evals to -,-,4,8,5,1dim=1, (ordered) values=7,18,1,5,1 evals to -,18,1,5,1
Trying to get the minimum value for this accumulated value however returns null for all variants I tried
aggr ( min ( if (rangesum(above(bincount,0,rowno())) > 7, bincount) ), dim)
Jürg