BusinessObjects Board

Syntax Error?

=<Actual Value> Where (<Fiscal Week> = Max(<Fiscal Week>))

Why won’t this work? (Sorry, I’m frustrated with this project and I’m at a loss even though I know it’s simple)


MBradbourne :us: (BOB member since 2003-08-28)

What exactly does not work :?:
What is the error message :?:

Andreas :de: (BOB member since 2002-06-20)

Syntax Error (DMB0007)

MBradbourne :us: (BOB member since 2003-08-28)

The “Where” clause can never include a variable, it must have the format:

Where (<Dimension> = Constant)

So what you need to do is set up a second variable, a flag if you will, something like:

MaxFlag = If (<Fiscal Week> = Max(<Fiscal Week>) Then 1 Else 0

Then try:

<Actual Value> Where (<MaxFlag> = 1)

There are a number of examples of this requirement in the archives. :wink:


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

Also covered in the Reporter FAQ
A simple search on BOB, keyword: Syntax Error (DMB0007) :wink:

Andreas :de: (BOB member since 2002-06-20)

This give a syntax error as well, same one…

Here is the problem… I’m trying to create a week to week variance report, and I can get it working , but when the next week come, it gets hosed (See the disappearing columns post) I think I figured out why the column is disappearing, so now I’m toying with solutions.

Max and Min Fiscal Weeks is the approach at the moment… is there a better way?

MBradbourne :us: (BOB member since 2003-08-28)