Main menu
You are here
Getting 30 values out of a 140 value array
Wed, 25/01/2006 - 07:00 — LS
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:
Getting 30 values out of a 140 value array
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
Getting 30 values out of a 140 value array
Thanks,
that works just fine.
LS