Peek Funation

GhazanfarAli — Mon, 24 Jan 2022 11:52:02 GMT

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;

topic Peek Funation in App Development

Peek Funation