
Re: Formula in set Analysis
Sunny Talwar Mar 22, 2017 5:15 AM (in response to Priyabrata Das )Would you be able to provide more details, may be a sample with expected output?

Re: Formula in set Analysis
Priyabrata Das Mar 22, 2017 6:05 AM (in response to Sunny Talwar )Hi Sunny,
Suppose we have 2 years i.e 2011 & 2012, For each year there are few students who are not graduated within 8 sem. So, we need to take those students for every year Divided by total no of students Like
2011 : 2 Students who could not graduated within 8 sem / Total students suppose 700
2012 : 5 Students who could not graduated within 8 sem/ Total Students suppose 645
Then : (2/700 + 5/645)/ 2 (i.e. no of years)

Re: Formula in set Analysis
Sunny Talwar Mar 22, 2017 7:16 AM (in response to Priyabrata Das )What what part of your above expression calculates the numerator and what is the denominator here?
Numerator?
((Count(Distinct {<Period={">=8"},Program ={'S'},Status={'Absence'}>} STDNUMBER)
Denominator
Count (Distinct STDNUMBER))
What is * Batch/ # of STDNUMBER?? Is that just a description?
May be try this
Sum(Aggr(
Count(DISTINCT {<Period={">=8"},Program ={'S'},Status={'Absence'}>} STDNUMBER)/
Count(DISTINCT STDNUMBER)
, Batch))

Re: Formula in set Analysis
Chntan Gala Mar 22, 2017 7:23 AM (in response to Sunny Talwar )May be Bach is the Year field.

Re: Formula in set Analysis
Sunny Talwar Mar 22, 2017 7:29 AM (in response to Chntan Gala)I agree and that is why I used it in my aggr() function



