Cummulative sum based on the date

[sruthi19]

Hi Team,

Please help me out -

I have month , createDate, Closeddate  fields

Month	CreateDate	ClosedDate	floor(ClosedDate - CreateDate
April	01-04-2021	02-04-2021	1
April	10-04-2021	20-04-2021	10
May	01-05-2021	04-05-2021	3
May	21-05-2021	26-05-2021	5
June	06-06-2021	06-06-2021	0
June	02-06-2021	30-06-2021	28

Output :

I want the cumulative sum (floor(ClosedDate - CreateDate)  for the related month.

Month	Cumulative Sum
April	11
May	8
June	28

[Quy_Nguyen]

Hi,

Try this expression for your cummulative sum: 

Sum(Aggr(Date#(ClosedDate,'DD-MM-YYYY') - Date#(CreateDate,'DD-MM-YYYY'), CreateDate))

[sruthi19]

Hi Nguyen,

Thanks for your response. But it did not worked for me.

[Quy_Nguyen]

Please take a look about your date format. In the given data in original post, its format is different. So you may need to change the Date# format in the expression to match with your format.

[sruthi19]

in original post i have given the sample data, but if you see the screenshot i have provided the right Date# format only - MM-DD-YYYY

[Quy_Nguyen]

Are you sure? I meant your date format in the app is M/D/YYYY.  

Try to make them using the same format. Or if it is already a valid date, use this:

Sum(Aggr(ClosedDate - CreateDate, CreateDate))

And remove the columns ClosedDate, CreateDate from the table - like the table you expect in the post

[sruthi19]

Thanks it worked.

Sorry for the late response