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.