A New Home in the New Year for SAP Community!

Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!

Apr 04, 2016 at 11:23 AM
# Using Where Operator

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.