"Where" operator in Business Objects XIR2

[Matt27]

I have a report in Business Objects XIR2 and I'm trying to create a variable to insert into the report using the Where operator. To start with, I created the following variable called "Months Between":-

= If (MonthsBetween(<Take On Date> ,CurrentDate()))>25 Then 1 Else 0

No problem with this at all. I then create a second variable:-

=Count(<Account Number>) Where (<Months between> = 1)

However, when I click OK to this second variable I get the error message "Syntax Error (DMB0007)". Is there any way round this?

 

[blom0344]

In BO the 'Where' operator is extremely restricted. However I would advice to define variables with names that stay clear of reserved expression.
(So, in any case <MM_btw> rather than <Monthsbetween> , just in case)

Does this work:

=If(<MM_btw> = 1) THen Count(<account Number>) Else 0

Ties Blom

 

[Matt27]

That's great thanks - that works when I put it in with my main block of data. In this main block of data I have a field called <Account Location>. If I wanted a seperate summary table to show the 4 values held in this field along with a total for the two variables I created above for each, how would I do this and avoid the #COMPUTATION error?

 

[blom0344]

Pretty hard to visualize where you're after.
Many a #COMPUTATION error can be solved by wrapping an aggregate function around the variable that displays the error. Like

'Max(<variable>)'

Ties Blom