PMT function in PEGA does not support 5th parameter "type" which is supported by EXCEL
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****