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 Darek,

 

I have tested the calculation, we are getting closer :)

 

This is what the results show:

 Mar-19Apr-19May-19Jun-19
Cambridge120126128129
London127127124120
Oxford104105103104

 

When comparing with the raw data it looks like for example for Jun 19, the members registered in June and the ones that have cancelled in June are missing. 

 

The calculation shows a total of 353 members in June 19, where the raw data shows that we should have 363  

I have noted that 4 members have registered in June and 6 have cancelled, which explains the 10 missing.

 

Any idea how the calculation could include those?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry but it's your responsibility to define what the meaning is of the numbers you want to calculate. I only implement the algorithm you give me. If the definition is not what you really meant, you have to change it and re-implement.

 

Sorry.

 

Best

Darek