Set Analysis OR Condition

[manojkulkarni]

Morning Friends,

How to write multi conditional OR statement in Set Analysis ?

I would need a condition to identify students who secured 90% in either Maths or Physics.

Below is the sample data

SID	Sname	Physics	Maths	Chem
1	ABC	95	90	90
2	XYZ	85	65	78
3	PQR	60	90	58
4	EFG	98	50	55

[arulsettu]

may be this

Count({<Maths={'>=90'}>}Sname)+Count({<Chem={'>=90'}>}Sname)

[manojkulkarni]

I am using the same expression. Is there a way to put both conditions in same set expression ?

[arulsettu · Accepted solution]

like this

Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)

[MayilVahanan]

Hi

Try like this

Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)

SID	Sname	Maths	Physics	Count({<Maths={'>=90'}>+<Physics={'>=90'}>}Sname)
				3
1	ABC	90	95	1
3	PQR	90	60	1
4	EFG	50	98	1

[MindaugasBacius]

OR statement in Set Analysis is represented as "+" sign.

=Count({<Maths={'>=90'}>+<Chem={'>=90'}>}Sname)

The syntax Count({<Condition1> + <Condition2>} FieldName).

[sravanthialuval]

Try like this,

The no of students who secured 90% in either Maths or Physics.

[manojkulkarni]

Thanks Arul,

I am using the same expression in original application it is not working, but it works with sample set of data. Need to check weird behavior of expression.

[arulsettu]

check the expression