Excel Patching for Different Columns

[mariverjean]

Hi,

So I'm working on like a loan payment app.

I just wanted to check if its possible to patch if the month of payment is equal on the month chosen by EE.

For example, if I input on the month of payment is January 2022, I want to patch the amount of payment input in January 2022 column.  Is this possible?

Or do you have any suggestions. I was trying to check if its possible so the outstanding balance will be computed real-time as well. Anytime I make payments, it'll be deducted since the Outstanding Balance column is in formula. 

Can you share possible logic? I was checking some but I cant find one. 

Thank you.

[v-qiaqi-msft]

Hi @mariverjean,

Could you please share a bit more about your data source?

Do you want to populate the Amount of Payment with a calculated number?

First of all, we should find out the last payment month and do calculation based on a sub between last payment month and input month.

If I input January 2022, I could find out the last payment as below:

Fist(Table1).LastPayment

Set the Default property of the Amount of Payment Textinput as below:

(DateDiff(DateValue(Fist(Table1).LastPayment),DateValue(Month_of_payment_TextInput.Text),Months)+1)*6990953