Is there a way to calculate average future balance in Tableau similar to how it is done in Excel?
Payment in Excel :
=ROUND(PMT(0.05/12,36,-20000,0),2)
Average Future Balance (array formula Press Ctrl+Shift+Enter) : =IFERROR(AVERAGE(FV(0.05/12,ROW(INDIRECT("1:"&24))-1,(ROUND(PMT(0.05/12,36,-20000,0),2)),-20000)),0)
Values:
Rate 5.00%
Present Value 20,000
Term 36
Average Life 24
Payment (Excel) 599.42
Average Balance (Excel) 13,879.62
Discount Factor (Calc) 33
Payment (Calc) 599.42
Average Balance in Tableau : ????
Tableau Calc:
- Discount Factor (Calc) :
(POWER(1 + [Rate]/12, [Term]) - 1)
/
([Rate] /12 * POWER(1 +
[Rate] /12, [Term]))
- Payment (Calc):
[Present Value] / [Discount Factor (Calc)]
- Average Balance in Tableau = ???????
1 answer
