Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Running Total in QLD

Hi,

Is there a way in QLD can have a running total like the Crystal Report capabilities? Is this possible in the Repetative Area1.

Example :

DocTotal Drawsum Result

500000 200000 300000

300000 100000 200000

200000 200000 0

The purpose of this is for Cash Advance Monitoring from AP Downpayment Invoice.

Is this possible by running difference / Balance ?

Thank you very much.

Regards,

clint

replied

Check these two queries. The Second one is what you could use and the first one is for reference.

SELECT T0.DocEntry, T0.BaseAbs, T0.DocDate, T0.CardName, T0.LineTotal, T0.DocTotal1 FROM Query_Result T0
ORDER BY  T0.BaseAbs, T0.DocEntry

SELECT T0.BaseAbs,T0.DocEntry, T0.DocDate, T0.CardName, T0.DocTotal1,
T0.LineTotal+(SELECT T0.DocTotal1-SUM(LineTotal) FROM  Query_Result WHERE DocEntry <=T0.DocEntry AND BaseAbs = T0.BaseAbs) [DocTotal], 
T0.LineTotal, (SELECT T0.DocTotal1-SUM(LineTotal) FROM  Query_Result WHERE DocEntry <=T0.DocEntry AND BaseAbs = T0.BaseAbs) [Running total]
FROM Query_Result T0
ORDER BY  T0.BaseAbs, T0.DocEntry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question