FinancePMT Calculcation/Formula Needed

[AMathis]

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

[AndrewDMerrill · Accepted 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)

[AMathis]

You are absolutely amazing!  That worked perfectly!!!!  Thank you so much