Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need Help

ankitgupta
7 - Meteor

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.

 

Product2018012201901202002
Enrollment204060
Cum Enrollment100140200
3 REPLIES 3
Inactive User
Not applicable

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
7 - Meteor

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 

 

Product201810201811201812201901
Enrollments60708090
Cum Enrollments100200300400
Cum_Enrollments_Output100170250340
SteveWayne
7 - Meteor

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

Labels