Partial Separation

[Sameer9585]

Hi,

I have a question to acquire the separation of the students who are passed,failed and partially failed.

Means if suppose there are three students A,B,C and there are 2 subjects and if A passed in all subjects he should be shown in passed and if B is failed in all subjects he should be shown in Failed and if C failed in one subject and passed in other then partial failed.

I need to achieve this help me

Thanks and regards

[Sameer9585]

Hi @Vegar ,

Any updates regarding the issue.

[Vegar]

To completely understand. What does your desired output for this data set look like?

[Sameer9585]

Hi Vegar,

Thanks for reply. So I actually want to do the given formula in the front
end and use that in the place of Result in the expression you have
mentioned earlier for the pass,fail and partial fail.

For example in the pass condition you have given that
Count({} distinct Name)

so in the place of "Result" I want the formula (Total-Invalid)/Total to be
done

I cannot do the formula calculation in the script. I want it to be done in
Expression only.

Please help me with this

Regards,

[Vegar]

I'm sorry, but I got stuck. Can't put more time into your question for now.  You will most likely need to create some kind if aggr expression to get this to work.  Maybe we can reach out to @tresesco  or @sunny_talwar  for help both have a good track record of finding solutions to problems like this.

[Sameer9585]

Hi Vegar,

Thanks for your help. I really appreciate it.

Regards,

[sunny_talwar]

Not entirely sure what you are looking to get... based on the sample inline table provided... would you be able to provide the output table in Excel?

[Sameer9585]

Hi,

Sheet 2 and 3 will give the clear idea

[sunny_talwar]

May be like this?

[Sameer9585]

Hi @sunny_talwar ,

Thanks for the reply but I want the names not in one column but in different rows.

Can we achieve that.

Regards,

[sunny_talwar]

Don't think it can be done without intervention in the script or a very complicated expression.... because the list could be long...