this year and last year as a variable

[system]

I linked it in my post, in case that wasn’t obvious.

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…

---

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