Close popover
kanagaraj senthurpandi (kanagarajs2878)
Mercedes Benz

Mercedes Benz
kanagarajs2878 Member since 2017 2 posts
Mercedes Benz
Posted: February 18, 2019
Last activity: July 3, 2019

PMT function in PEGA does not support 5th parameter "type" which is supported by EXCEL

Hi All,

We have a new business requirement to use PMT function to calculate the monthly rental. The PMT function currently used using excel has 5th parameter "type" (PMT(rate*30/360, nper, pv, [fv], [type]). But the PMT function in Pega version 7.1.8 does not have this 5th parameter. Need your suggestion to know whether this needs any upgrade to PEGA version? or any hotfix to be applied? or can I write a custom function using the pega provided PMT function adding the additional parameters?

Thank you in advance.

***Edited by Moderator Marissa to update platform capability tags****

Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.