Forcasting on dates from percentages in periods

[simonroyjones]

Hi

I am trying to forecast income from new business based on the previous performance of similar types of business.

I have managed to analyse the previous performance by subdivisions and analaysed how its performed after month1, 2, 3 etc.

I also have new business files subdivded in the same way.

The issue I have is representing  the forcast percantage for mth1, 2 etc as values on dates.

My data is as follows.

Lookup Table that shows % collected after each time period subdivided by score

My new business file looks like:

And I'm looking for out put similar to the below py applying the percentage income over time to the new business file.

I hope this makes sense.

Thanks

Simon

[Pragati11 · Accepted solution]

Hi @simonroyjones ,

You will require a date column in your data to get the income over time.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[simonroyjones]

Thanks Pragati

I wondered if that might be the case.

As I recalculate the forecast data every night in SQL I can add the dates.

I'll rebuild the data as below.

Thanks for the advice

Simon