Skip to Content
0
Nov 12, 2012 at 12:43 PM

Multi Conditions in Where

28 Views

Hi all,

I build a WEBI report using BEx query .I need a variable calculating the number of students satisfying more than one condition.

I have a BW char Department and a WEBI variable Class. I need to calculate the number of students whose department is "Maths" and class="1".

Note that this varialbe will not be used in a table, it will be used as a single cell so I need to use foreach. I tried a combination of where, and, foreach but failed.It calculates the number of student of class="1" and department="Math" sepearately but I could not combine those two.