usage of the "where" clause with a variable...

[system]

There is a FAQ about this:

120×120 10.4 KB

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 ano…

Essentially you have to create two variables, one that captures the UserResponse() value and sets a flag, and then use that flag within the Where clause of the next variable.

---

Dave Rathbun (BOB member since 2002-06-06)