Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

FinancePMT calculation help

paul_houghton
12 - Quasar

Im calculating monthly payments using the Finance PMT calculation and Im not sure what the convention for the "PayAtPeriodBegin" argument is. Is it a 1 for at beginning of period and 0 for at end?

 

FinancePMT(Rate, NumPayments, PresentValue, FutureValue, PayAtPeriodBegin) 

Thanks

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@paul_houghton,

 

That is what the formula reads from microsoft.  The difference there is that the default value is due at end of period.  If you test in comparison with their function, you should get the same results.  I tested using:

http://www.calculator.net/finance-calculator.html?ctype=contributeamount&ctargetamountv=1000000&cyea...

 

I got same/similar results. 

 

1 = Beginning & 0 = End

 

Screen Shot 2017-02-10 at 9.24.54 AM.png

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
paul_houghton
12 - Quasar

Magic thanks, I wasnt sure if it was the microsoft syntax

 

giphy

Labels