Calculating order quantity change wrt to average of previous weeks

[amansinghfirstb]

I am having trouble understanding the problem in the code for a simple feature of finding order quantity fluctuation % wrt to the average demand of the selected previous weeks (selected through filter).

The Qty column is a rolled-up number and it has many instances of Scheduled Wk, but I want to capture the average of the rolledup summaries like this table shown below.

In the table

Business Units	Qty	Scheduled Wk
ASCE	3500	1
ASCE	4500	2
ASCE	400	3