Balance sheet using array fields

[mbDutch]

I need to write a balance sheet type of report that shows by tax year and period, the account number and the balance for that account number. However, let’s say that whoever runs the report selects tax year 2008 and period 5, they will want to see that period, as well as the previous 12 periods (2008 – period 4, 2008 - period 3 etc).
However, the period is determined by the array number of the field. So for instance
“Cur-balance[4]” shows the balance for period 4. So the detail lines look somewhere along the lines of:

Account # Tax Year# Balance (12 array field)
45000 2007 $100;$120;$115 etc
45000 2008 $90;$160;$100 etc
47000 2007 $1000;$1050;$1100 etc
47000 2008 $900;$1200;$1150 etc

And what we would like the end result to be is:
Someone selects the Parameters: Tax Year= 2008, Period = 5 then the report will display:

Period 5 / 2008 Period 4 /2008 Period 3 / 2008

45000 $90 45000 $160 45000 $100
47000 $900 47000 $1200 47000 $1150

Etc.

Assuming this would be possible, I am looking for some advice on how to best approach this?

Thanks in advance.

Marco

 

[lbass]

I don't understand what this is: $100;$120;$115 etc

Is this one instance of a field {table.Balance}? If it is a formula, please show the contents of the formula. Also provide the {table.field} name.

-LB

 

[mbDutch]

Hi LB -

Yes it's one instance of a field. The field is called "Cur-Balance" which is basically 12 balances (arrayed) in one field.

 

[lbass]

So they are arrayed in the field in descending order from Period 12 to Period 1? And to identify a particular array component, you would have to use the following?

split({table.cur-balance},";")[1]

If this is the case, then is the issue how to relate this to the parameters?

-LB