This content has been marked as final.
Show 3 replies

1. Re: How to calculate field to arrive compounded future values? Tableau Desktop 10.1.5
Yuriy Fal May 14, 2017 11:12 PM (in response to Vahur Madisson)1 of 1 people found this helpful// Compounded_total
IF FIRST()==0
THEN ZN(SUM([Total_flow]))
ELSE PREVIOUS_VALUE(0) * (1+[Monthly_Interest]) + ZN(SUM([Total_flow]))  LOOKUP( ZN(SUM([Total_flow])),1)
END
Compute using > Dates

2. Re: How to calculate field to arrive compounded future values? Tableau Desktop 10.1.5
Vahur Madisson May 23, 2017 8:53 AM (in response to Yuriy Fal)That is great, it will do the job!
Many thanks!

3. Re: How to calculate field to arrive compounded future values? Tableau Desktop 10.1.5
Yuriy Fal May 23, 2017 10:00 AM (in response to Vahur Madisson)Vahur, you're welcome.