Skip to Content
Former Member
Oct 17, 2011 at 06:49 PM

Placement and creation of a dynamin array


I have a report that returns between 100-200 records.

Sorted by @name+date

It is only 3 data columns.

Name - allocated - date

What i want to do is create a 4th column which is the

calculated by "current allocated" - "previous allocated"

i have this working with a formula that uses PREVIOUS/NEXT

However i am unable to total/summary this formula or even

see it(see Summarize a formula which has Next/Previous)

so what i want to do is create a dynamic array for each column.

Name - allocated - date

How or where do i place the formula that holds the array data ?