5 Replies Latest reply: Mar 22, 2017 7:29 AM by Sunny Talwar

# Formula in set Analysis

Hi All,

I have a formula like :

((Count(Distinct {<Period={">=8"},Program ={'S'},Status-={'Absence'}>} STDNUMBER)

/

Count (Distinct STDNUMBER)) * Batch) / # of STDNUMBER  of each batch.

Here Batch is like 2010/2011 format.

So for example : 2011 batch : 20/700, 2012 batch : 5/345  Total : (20/700+5/345)  / 2.

Please help in how to achieve this in set analysis

• ###### Re: Formula in set Analysis

Would you be able to provide more details, may be a sample with expected output?

• ###### Re: Formula in set Analysis

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

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

May be Bach is the Year field.

• ###### Re: Formula in set Analysis

I agree and that is why I used it in my aggr() function