excel function PMT in outsystems
Question
Application Type
Reactive

Hello,

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)

functionBET.PNG

Hello,
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 

Example

Good luck, 

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