Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cumulative calculation issue

Good morning,   I have 2 tables, 1 is a calendar table, the other one is a table showing new members per location with their registered date and cancellation date, see below:   UniqueID Regis...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Darlove,

 

Thanks for your patience,

so, as per you example, for a selected period of Jan-2018, the "cumulative new registered" is count UniqueID where "Registered Date" <=31-Jan-2018 (as it needs to also include all the new members that have registered in January)

 

And the "Cumulative of Cancelled" for the same period is the count of UniqueID where "Cancelled date" <= 31-Jan-2018

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If the code I've given you is correct, please mark the post as THE answer.

 

Thanks.

 

Best

Darek