Quick screen

[Johnson, Harold A EDUC:EX]

You could possibly add a reference file that occurs with the primary
cluster, keyed on data that points back to the previous year for each line.

ie: line 2 with yr=71 and prt=2 can reference the reference file as yr=72
and prt=1, etc..

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of terry terry
Sent: 2005 April 26 10:43 AM
To: powerh-l@lists.sowder.com
Subject: Quick screen



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/

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.