Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
For doing this in the script you will have to use Group By statement with may be multiple resident loads