KNOWLEDGE BASE

Fvschedule Function Is Not Available


Published: 20 Dec 2019
Last Modified Date: 23 Dec 2019

Environment

  • Tableau Desktop

Answer

Similar calculations can be used. Example:

In Excel: =FVSCHEDULE(1,{0.09,0.11,0.1})  - Future value of 1 with compound annual interest rates of 9%, 11%, and 10%.

In Tableau: ((SUM([Sales]) * 1.09) *1.11) *1.10) - Future value of SUM([Sales]) with compound annual interest rates of 9%, 11%, and 10%.
Did this article resolve the issue?