I'm attempting to create an Alteryx formula to replicate a current formula we have set up in PowerBi and cannot seem to get the correct calculation.
I need to formula to calculate the monthly payment based on the criteria below (see screenshot):
PMT = round(PMT(('Lease Query'[lse_int_rt]+'Lease Query'[prc_sbsdy])/100/12,'Lease Query'[lse_term],-'Lease Query'[tot_cap_cst],'Lease Query'[rsdl_amt]),2)
lse_int_rt | prc_sbsdy | lse_term | tot_cap_cst | rsdl_amt | mthly_rnt_amt | PMT |
2.349 | 0.95 | 60 | 38260.12 | 9435 | 547.76 | 547.73 |
2.349 | 0.95 | 60 | 38964.68 | 9435 | 560.52 | 560.48 |
Solved! Go to Solution.
I managed to get the same output with the following formula (Just don't ask me why...).
Round(
-FinancePMT(([lse_int_rt]+[prc_sbsdy])/1200, [lse_term], [tot_cap_cst], [rsdl_amt],0)
,0.01)
You are absolutely amazing! That worked perfectly!!!! Thank you so much