Using Where Operator

38 Views

Hello all,

I'm trying to use the count function to sum two different measures in BusinessObjects webi 3.1.

I need to only add certain elements of the second measure if a certain condition is true, for example:

=Count([Incident Group One])+Count([Incident Group Two])Where(Condition=True)

The dimension containing the condition would be extremely simple, labelling each incident in a group True or False based on a certain test.

I have the dimension containing the condition working, as I have created a simple vertical table to check and the 'True' or 'False' is being applied correctly to each incident.

The problem appears when I try and only count certain incidents in the second group based on where the condition is true. I'm not sure if it is possible to use the Where operator or I need to find a different method.

Any help would be greatly appreciated.