Future forecasts based on current revenues

Fri, 07 Nov 2014 18:13:29 GMT

Hi guys,

Need to create a revenue forecast of service contracts (so called Renewals, Subscriptions, etc.) based on the revenue of these contracts that has been generated in the past already.

First: We simply want to know the amount of revenue we probably will generate in future, when renewing those contracts.

XDatumEND is the latest month, the contract needs to be renewaled.

All information is stored in a SOURCE Table.

BUT not all of these contracts are of the same runtime.

Most of the time contracts are sold for a period of 12 months (see first three rows of Source Table). But some are of a different duration (see row 4 and 5).

How to achieve a forecast based on an estimated future 12 MONTH (!!) renewal as stated in the screenshot?

Any ideas are pretty appreciated as I'm getting crazy soon...

Many Thx

Joerg

topic Future forecasts based on current revenues in QlikView

Future forecasts based on current revenues