Creating a Principle and Interest calculaltor

(0) Share

Report

Posted on by cnr

144

Hi all,

I'm trying to achieve the below output that I have here in excel into PowerApps:

However Im currently stuck on this - where my first record is repeated for all 8 records.

But what I need to do is to have the following record take the new Principle, then multiple it by my Rate (0.06) to give the Interest

So record 2's interest would be 4,117,200 (68,620,000 * 0.06)

Ive been trying to use a mix of ForAll, Sequence and Clearcollect but I have not luck so far - Would greatly appreciate any insights

Thanks

Conor

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@cnr

If you could share some of the formulas you have tried and anything you feel is close but not working, that would be helpful.

Is your formula based on a straight line interest of 0.06 per period based on the prior period?

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (1)

Report

@cnr you need to implement this like a while loop, please check this out

https://www.dynamicpeople.nl/en/news/while-loop-powerapps/

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (1)

Report
@cnr I followed the steps in this link https://www.dynamicpeople.nl/en/news/while-loop-powerapps/

spend a lot of hours but I and was able to implement this 😎

Most of the code is same except for OnTimerEnd

Collect( colTimer, {item: "I am item" & varRuns + 1} ); //Logic for interest calculator starts If( varRuns = 0, Set( varPri, Value(TextInput1.Text) ); Set( varInt, Value(TextInput1_1.Text) / 10 * varPri ); ClearCollect( myCollection, { Pi: varPri, //73000000 Int: varInt//4380000 } ); , Patch( myCollection, Defaults(myCollection), { Int: varInt, Pi: varPri } ); Set( varInt, varInt ); Set( varPri, varPri ); ); Set( varPri, varPri - varInt ); Set( varInt, varPri * Value(TextInput1_1.Text) / 10 ); //Logic for interest calculator ends UpdateContext({varRuns: varRuns + 1}); If( varRuns >= varLoopEnd - 1, UpdateContext({varTimerStart: false}) )

Please attached app for your reference, please download and try it.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

InterestCalculato...

Was this reply helpful? Yes No
cnr 144 on at

Like (1)

Report

Thanks @jinivthakkar,

This was very helpful. I've almost got it to work, its definitely put me on the right track. Appreciate you taking the time!

Was this reply helpful? Yes No