Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
Try this expression for your cummulative sum:
Sum(Aggr(Date#(ClosedDate,'DD-MM-YYYY') - Date#(CreateDate,'DD-MM-YYYY'), CreateDate))
Hi Nguyen,
Thanks for your response. But it did not worked for me.
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.
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
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
Thanks it worked.
Sorry for the late response