Forum Discussion
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...
Well, until you show what the correct results should be... nobody will be able to help you. Please state in words, but precisely like you do in mathematics, what it means "Cumulative new registered" and "Cumulative cancelled" for any selected period of time. Thanks.
Hi,
Thakns for your reply
The results should look like this:
Numbers of Members per location Jan-18 Feb-18 Mar-18 Apr-18 May-18 … Cambridge 123 120 126 128 129 … London 122 127 127 124 120 … Oxford 106 104 105 103 104 … Cumulative new registered is counting all the members that have been registered so far.
Cumulative of cancelled will count all the members that have cancelled their membership.
Hope this helps.
- "Cumulative new registered is counting all the members that have been registered so far." Well, that's not particularly clear. Say you have selected a period of Jan-2018. Does "Cumulative new registered" mean that you count UniqueID's where "Registered Date" is < 1-Jan-2018? Or "Registered Date" is <= 1-Jan-2018? Or something else entirely? The other one is also not clear enough. Should "Cumulative cancelled" be the number of UniqueID's where Cancellation Date <= 31-Jan-2018? Or something different? Please state the conditions clearly using the entities in your table.
Thanks.
Best
D.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