How to correct Average Selling price due to regular Collections

Hi All,

We are facing issue with Sales Represetative Updates in worksheet.

sales rep will enter Units and ASP at Hight level (In our case# Customer, RSM, Quarterly Time). Units are proportional to Last Quarter actuals sales. ASP is copy down to below levels. In the worksheet we will Show revenue as Weighted ASP multiply by Units.

For ex: 5 ASP, Qty#4 at higher level, it shows around 20 Revenue, and it is expected behaviour.

When we run collections, due to Master data change or new sales, system creating weekly bucket of new combinations. And these newly created combinations Units are null and ASP is null.