Need Help

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

Data Investigation

Accepted answers

SteveWayne

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

Cummulative Example.yxmd

All comments

unknown

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.

Cummulative Total Example.yxmd

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703