How to count the number of <whatever> between two date

[system]

Try:

Count (...) WHERE ( ...)

And see the FAQ Reporter Entry:

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…

---

Andreas (BOB member since 2002-06-20)