Caluculated Period from Current Date in WEBI

[system]

Hello BO Gurus. Please help me with this. I am trying to equate the period to Current Month from system date . I think there is some absolute or format error since if I hard code the period = 10 it works but I use the below it does not work

Not working code
=Sum([Cumulative Balance]) Where ([L01 Posting period] = (“Month(CurrentDate())”))

Code which is working is below but I want to derive the period that from system date or current date. example take only 10 from system date Please help me correct the code in WEBI

=Sum([Cumulative Balance]) Where ([L01 Posting period] = (“10”)

Soniya

---

Soniya (BOB member since 2008-09-30)

[system]

Hi, there is a FAQ on this in the Desktop forum that is appropriate here as well. Basically you cannot use a variable in a where clause, you need to have a constant. A solution that might work for you is outlined here:

FAQ: Reporter

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…

Just be sure to change the syntax in the example to Webi.

---

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