How can we accumulate the previous year data in the Month of january,2013

[#1]

Hi,

I have a one requirement to run on every month of 2013. The data should be listed till the current moth. As in our data base the Members are joined in 2010, 2011,2012 & 2013, Now i have to count the Number of enollees  at End of the Each Month. For Example There are 19 members are enrolled till the end of January,2013, Out of 19 Members, 10 Members are enolled in 2011 Regardless of month and 9 Number are enrolled in January, 2013. So the total number of Enrollees at End of January month is 19.

I am using the below set expression for getting of 19 members who are enrolled till the end of the date at January,2013 But i am getting 9 Members only who are enrolled in january of 2013. Still I have to count the previous year data in my requirement.

=SUM(IF(ACTIVE=1 And DType=1 And JOIN_DT<=MTH_END,RNK))

Enrollment	Jan		Feb		Mar		Apr		May
Number of Enrollees At Beginning of The Month

Like Similar way i have to accumulate the rest of the months data.

[MayilVahanan]

Hi

Can you please provide a sample file?

Did you check both date are in same format and also both have status 1 for active and dtype?

Check once,

=Sum({<Active = {1}, Dtype = {1}, JOIN_DT = {"<= MTH_END"}>}RNK)

or

=Sum({<Active = {1}, Dtype = {1}, JOIN_DT = {"=JOIN_DT <= MTH_END"}>}RNK)

Hope it helps