Why do I get a Syntax Error (DMB0007) when I try to Sum() Where ( > 2000)?
The syntax of WHERE Clause is:
measure Where (dimension = (number or character string or date, dimension = …))
This means that the WHERE Clause in Business Objects Reporter only allows the “=” operator, and the right side of the equation has to be a constant as well (and not another report variable etc.).
For example:
Sum(<Sales>) Where (<Year> = 2000)will work
Work around for original problem:
Create another local report variable “VAR Flag Is Year greater than 2000” defined as:
= (<Year> > 2000)This will be a boolean variable returning 1 or 0.
Make sure that the universe object is of Data Type Number.
Now modify your original formula to use:
Sum(<Sales>) Where (<VAR Flag Is Year greater than 2000> = 1)Cindy Clayton 
(BOB member since 2002-06-11)