Can anyone help with the following:
I want to count where the value of one of its measure objects is equal to “X”. The measure object is actually a variable that was created within the report itself. When I try to Count() Where (=“X”) it gives me syntax errors or incorrect data type. This did not seem like it would be a difficult task but as I have been reminded of over and over in BO, it is always more cumbersome than it appears. And as usual, HELP was anything but… Thanks for any suggestions.
Count( Where (=“X”) ) ‘)’ is different or
Count( if =“X” then ) this should produce the same result
in stead of
Count() Where (=“X”)
The biggest problem however is that this only works if Object1 is a measure (if not syntax error) and variable1 a dimension
One possible solution :
create a variable CountObject : =if =“X” then 1 else 0 and now =sum(CountObject) should do the work
Op this helps
Peter
“Robertson, Michele R” ROBERTM1@SCE.COM 14/10/98 1:58:39 >>>
Can anyone help with the following:
I want to count where the value of one of its measure objects is equal to “X”. The measure object is actually a variable that was created within the report itself. When I try to Count() Where (=“X”) it gives me syntax errors or incorrect data type. This did not seem like it would be a difficult task but as I have been reminded of over and over in BO, it is always more cumbersome than it appears. And as usual, HELP was anything but… Thanks for any suggestions.