This is a big ask, but I just can’t figure out how to setup this formula. I’m trying to determine the Step 1 “Initial Trial Balance”. The initial trial balance is the lowest account balance for any given month in a 12 month period. The amount can ...
Here is the scenario. I have a formula field in Table A {Loan Amount}, that calculates the loan amount based on two other fields in Table A. Based on the resulting value in that {Loan Amount} formula field, I would like to to reference the cost of ...
I can’t seem to figure out this formula. Here is what I would like to do.
Compares today’s date with a specific field date. If today’s date is after field date I want to multiple field A by 10. If today’s date is before field date, then I want to...
I’d like to calculate a Currency Figure {Loan Amount} based on either a exact dollar amount deduction or percentage (without having to enter both).
For example, if I want to calculate a {Loan Amount} from a {Purchase Price}, I can easily do this with...
I just noticed that, thank you. There is something that still isn’t working perfectly on the USDA ones. The Initial Deposit For Your Escrow account number is off. I verified the addition you made to the 12 month formula is working though and it ap...
Thank you Jeremy, I will try adding that formula to the field and running a few tests. I believe it is always the 12th month, so that should work.
I also appreciate the info on the ROUND() function. I have noticed on occasion that a few of my calcu...
@Jeremy_Oglesby I ran a few more scenarios and found one issue with the formula. If the “Loan Program:” field = “USDA” then we have to add another amount to the 12 month minimum calculation. I was able to adjust the monthly escrow amount to accou...
@Jeremy_Oglesby Indeed, it appears you’ve solved it! I added a few more records to the base and sure enough, the formulas you created resolved with the correct answer (except for one of them, but that is because that 1 has a 4th tax amount). I th...
