6 Replies Latest reply on Jul 20, 2013 4:04 AM by Neil Sequeira

    Forecasting periodically escalating revenues

    Neil Sequeira

      Is it possible, using Tableau calculations, to create a forecast for three fiscal years with the following basic information:

      • Start date of a contract (as also its anniversary date for escalations)
      • the escalation rate (escalation kicks in on every anniversary date)
      • amount per annum (or sometimes by month)

       

      Fiscal year begins in April.

       

      There is of course other information that will be used to slice & dice (profit centres, vendors etc).