I am working on calculating the Weighted Average of Sales for different months.The expression used is

[#1]

I am working on calculating the Weighted Average of Sales based on Year(Order_Date) and Month(Original_Sales_Date).

The expression used is

SUM(Total_Sales * Average_Sales)/SUM(Total_Sales).

The above expression works fine when used in a Chart Expression.

However, when I write the same expression in the Script, it is not loading the correct data.

Need help in solving this issue.

[sunny_talwar]

For doing this in the script you will have to use Group By statement with may be multiple resident loads