Quick screen

[terry terry]

Hi,
   I have a Quick screen (PH 7.10.G3) whereby every second half of the year
   before interest could be calculated, the previous int-amt has to be
  subtracted from the b/f amount(brought forward amount). The problem for me
  is that these fields are cluster fields and so I have no way of
referencing a previous field .Can you please help. Thanks in advance.


Every second half of year:
int-amt= b/f amount - previous(int-amt) * interest


yr prt      b/f amount    cont amt      tot-amt  interest int-amt   c/f amt

72  1           0              50.00            50.00     4 %      2.00      
52.00
72  2           52.00       100.00         152.00     3 %      1.50     
151.50
73  1          151.50       50.00          201.50     5 %      7.58     
209.08
73  2          209.08       100.00        309.08     6 %     12.09     
313.59

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/