excel function PMT in outsystems
Application Type


I'm making an outsystems application based on a excel sheet

in the excel sheed there is function PMT. It calculates the payment for a loan based on constant payments and a constant interest rate. 

i dont know hot to calculate this formule in outsystems (see screenshots from excel in the attachemtents)


If I understood well you are talking about the Excel PMT Function? 

I don't think there is any build in function or forge for it, but you can implement it easily. 

you have to prepare your data model to host data then build the function, via server action or even JS 


Good luck, 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.