6
Hi,
I am developing a canvas app that involves financial calculations that are normally calculated in Excel.
I am struggling with the calculation of rate and nper in PowerFx.
I am hoping that someone can help write the following excel formulas in PowerFx:
RATE(nper, pmt, pv, [fv], [type], [guess])
NPER(rate,pmt,pv,[fv],[type])
to truly implement this you would need to run an iterative algo that approaches the desired payment until a tollerance is met at which point it can output the calculation. This seems like it would be a nightmare in powerapps and would definatly have a good chance of not being as accurate. You could look into custom functions. I am on a mac and so dont have desktop version and therefor cannot look into them for you unfortunately. I will play around with this and see if i can get something that works at all.
The other option is to use excel connector to calculate the RATE and then just read it from the file. This may be a work around but would be relatively easy to do using a flow.
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
