Need experts help here as have been banging my head against this for awhile. Tried using @OwenAuger s circular reference calculation but was unable to as my issue has percentages. Here is the issue i need to do a simple amortization of a balance.
i have one table containing the amortization in percetages with a time index. See below:
I have another table with the balance:
All i want is to apply -.1*1,000,000=900,000 for the first time period then for the second time period start with 900,000 and multiply that by -0.2.
Here is what i can come up with, as you can see it's not working right.
The Amort measure is as below:
(-[Initial Balnce Measure2]*[Market Factor])
I cant change it to reference the closing balance as it creates a circular reference.
Closing Balance calculation is as below:
Closing Balance =
[Initial Balnce Measure2]+[Amort Cumulative]
I realize there must be a simple answer to this. Appreciate your help!