Peek Funation

[GhazanfarAli]

Anyone can help me with that, it is not working as it should be.

PaymentPlan:
LOAD
*, If(%Key_LoanNumber=Peek(%Key_LoanNumber), Peek(period)+1, 1) as period,
//,if(peek(%Key_LoanNumber) = %Key_LoanNumber, peek(BalanceEOP2),balance)-(pmt((air/12),term,-peek(BalanceEOP2)))-(peek(BalanceEOP2)*(air/12))) as BalanceEOP2
if(%Key_LoanNumber=peek(%Key_LoanNumber),Peek(Balance_eop)-(pmt((air/12),term,-peek(balance_eop))-(peek(balance_eop)*(air/12))),balance) as balance_eop



resident Paymentplantable

order by
%Key_LoanNumber
,Year
,Months;
drop table Paymentplantable;