Hi Everyone!

Please help me on below query..

I have to work on daily revenue analysis project. I just creat this anlaysis at excel. Following points to be cosider for the same:

- For daily report, there are approx 150 sub reports from where we have to pick the revenue.
-Above report are basis of different sources, so there is possibility of missing some random report on daily basis.
-Now in my project, structure is like I have to prorate revenue for those days where same report not received for previous days.
-Now my problem is proration of that reports.
-Is there is any way who work like that.

>>> If previous days revenue is > 0, then total revenue -sum of all days revenue in month would be prorate in incremental days.

If some one have idea to do some better pls also share..

Thanks