Finding common values

[naveenchellaara]

Hi,

We are having a requirement where we need to display the count of students enrolled in a camp. We have two time periods in the report. Current time period (selected by the user) and the previous time period ( time period selected by the user - 1 year). We need to find students who have their status as enrolled in both time period.

If the user selects Jan 2014 as the current time period, then the previous time period will be Jan 2013.

Set 1 - Students enrolled in Jan 2014.

Set 2 - Students enrolled in Jan 2013.

I need to find the intersection of the two sets

Thanks in Advance

Naveenchellaaraam.D

[vikasmahajan]

This is possible please request you to put some dummy records in excel for 4,5 students , some thing like wise comparison you want .

Vikas

[sivarajs]

Count({<year={">=$(=Max(year)-1)<=$(=Max(year))"}>} StudentID)

[Gysbert_Wassenaar]

Something like this:

count({<Status={'Enrolled'},Month={'$(=only(Month)'},Year={'$(=only(Year))'},StudentID=p({<Status={'Enrolled'},Month={'$(=only(Month)'},Year={'$(=only(Year)-1)'}>}StudentID)>}distinct StudentID)