You are here

Getting 30 values out of a 140 value array

hello,

i was wondering if there was an easier way to get values out of an array
than what i am previously getting.

i need the first 20 values, and then every 30 values after that
out of a 140 value array.

i think i should use
element([array],1) + element([array],2)...........+ element([array],30)

but how can i condense this command?

cheers

LS

Forums: 

You can construct a smaller array from values in the larger one, then sum that.

To construct an array, use makearray(value, size), and inside the value expression you can use place_in(1) to get the index of the value in the new array.

So to sum elements 21 to 50 of a big array you would go

sum(makearray(element([array],place_in(1)+20),30)

Hope it is apparent how this formula works!

--Jasper

Thanks,

that works just fine.

LS