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