CDS - Accumulation value from column

hassin — Mon, 10 Oct 2022 15:10:59 GMT

Hallo,

I have the current situation/problem and hope you could help me out.

Let's assume we have the following table:

I would like to accumulate the 'Status' in order of the date and when the month change I would like to start with zero:

Which kind of CDS syntax can I use to sum the status and considering the date in right order?

How can I translate this SQL syntax into CDS syntax:

SUM(Quantity) OVER (PARTITION BY AccountID ORDER BY ID)

Regards

Hassin

topic CDS - Accumulation value from column in Application Development and Automation Discussions