How to work with Aggregations

[system]

Look at this in the Business Objects Classic (Reporter) FAQs:

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…

Judy

---

JMulders (BOB member since 2002-06-20)