Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

CDS - Accumulation value from column

hassin
Explorer
0 Kudos

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

0 REPLIES 0