2001-01-01
Debt 1
-100000
1.2
2001-01-02
Payback
20000
1.3
2001-01-03
Payback
15000
1.25
2001-01-04
Debt 2
-100000
1.1
2001-01-05
Payback
50000
1.05
2001-01-06
Payback
115000
.95
2001-01-07
Debt 3
-110000
1.2
2001-01-08
Debt 4
-60000
1.15
2001-01-09
Payback
100000
1.1
2001-01-10
Payback
50000
.9
2001-01-11
Payback
10000
1.1
2001-01-12
Debt 5
-10000
1.3
2001-01-13
Payback
20000
1.2
Simple
Transaction Amt
>
0
[Transaction Amt] > 0
Warning
All
ByName
RunTot_Transaction Amt - Ascending
Sort - Ascending
Date
Extra
Int32
4
Empty
if [Type]='Payback' then 0
elseif [Row-1:RunTot_Transaction Amt]=[RunTot_Transaction Amt] then 0
else [Row+1:RunTot_Transaction Amt]-[RunTot_Transaction Amt]
endif
if [Type]='Payback' then 0
elseif [Row-1:RunTot_Transaction A...
Date
Date2
Date
10
Empty
[Row+1:Date]
[Row+1:Date]
Date
Type2
V_WString
20
Empty
[Row+1:Type]
[Row+1:Type]
Simple
Extra
>
0
[Extra] > 0
Warning
All
ByName
#2
#1
Transaction Amt
NewField
Int32
4
Empty
[Transaction Amt]-[Row-1:Extra]
[Transaction Amt]-[Row-1:Extra]
Date - Ascending
Simple
Transaction Amt
>
0
[Transaction Amt] > 0
Warning
All
ByName
RunTot_Transaction Amt - Descending
Sort - Descending
Transaction Amt
Debt
V_WString
20
Empty
if [Row-1:Transaction Amt]<0 then [Row-1:Type]
elseif [Transaction Amt]<0 then [Type]
else [Row-1:Debt]
endif
if [Row-1:Transaction Amt]<0 then [Row-1:Type]
elseif [Transa...
Date - Ascending
Simple
Transaction Amt
<
0
[Transaction Amt] < 0
Date
ROE2
Double
8
Empty
[Row+1:ROE]
[Row+1:ROE]
Gain/Loss = -([ROE]-[Debt_ROE])*[Transaction Amt]
Type = IF [Transaction Amt]<0
...
Horizontal
Debt Payback