Need Help

[ankitgupta]

Hi All,

I am looking for a solution on one of the problem I got stuck, I have a table like below where I want to calculate Cum Enrollments . The way I want to calculate this is : Cum Enrollment of 201812 = 100 + Enrollment 201901 = 40 => Cum Enrollment 201901 =140. Can someone pls guide how to do this.

Product	2018012	201901	202002
Enrollment	20	40	60
Cum Enrollment	100	140	200

[Inactive User]

Hi @ankitgupta 

There are various ways to go about it. I've created an example that should work for you. In particular, it will work generically to allow for more dates added later.

BR

[ankitgupta]

Hi @Inactive User , thanks for looking into it, but the kind of solution that I am looking here should have first value in Cum Enrollments should be constant in the output and then things will be calculated like this for Cum_Enrollments_Output:

• 201810 : 100 (Same Value of Cum_Enrollments)
• 201811:   201810 (Cum_Enrollments_Output) + 201811 (Enrollments) = 201811 (Cum_Enrollments_Output) : 170 
• 201811:   201811 (Cum_Enrollments_Output) + 201812 (Enrollments) = 201812(Cum_Enrollments_Output) : 250

E.G 

Product	201810	201811	201812	201901
Enrollments	60	70	80	90
Cum Enrollments	100	200	300	400
Cum_Enrollments_Output	100	170	250	340

[SteveWayne · Accepted solution]

I'm not sure i see the role of "Cum Enrollments" in the example, except perhaps to represent pre-existing enrollments prior to the first date?

You can cater for this by adding 40 to the cumulative totals (80 in the first example)

See attached

Steve