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.