Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to write an accumulation script but I am unable to succeed.
May you assist me, please?
SalesAggFinal:
LOADYearMonth,"Group",Quantity,TotalPriceBeforVat,TotalPriceBeforVat/Quantity as unitpriceFROM [lib://DB/SalesAggFinal.qvd]
(qvd);
SalesAggAcc:
LOAD "Group",YearMonth, TotalPriceBeforVat, RangeSum(peek('Cumulative') , TotalPriceBeforVat) AS TotalPriceBeforVatCumulative
Resident SalesAggFinal;exit script
Before:
After:
What do I need to do?\