=<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)
-Mark
MBradbourne (BOB member since 2003-08-28)
=<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)
-Mark
MBradbourne (BOB member since 2003-08-28)
What exactly does not work
What is the error message
Andreas (BOB member since 2002-06-20)
Syntax Error (DMB0007)
MBradbourne (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.
Dave
Dave Rathbun (BOB member since 2002-06-06)
Also covered in the Reporter FAQ
A simple search on BOB, keyword: Syntax Error (DMB0007)
Andreas (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 (BOB member since 2003-08-28)