Use UserResponse in Formula

[system]

[b] How to use UserResponse in a formula…
Ex:

where(= UserResponse(“DP”, “Select Month”) )
[/b]

This is because …in my report I need to find the revenue difference between current monthe and the previous month. So i will get the two month (prompt) from the user.It will give me the list view. Then i will inset two column and filter tthe revenue live [ where(= UserResponse(“DP”, “Select Month”) )] accordingly, and another colum to find the difference.

Also suggest, Is there any another better method to achieve this.?

Thanx in advance.

---

mmvraja (BOB member since 2004-02-26)

[system]

Have a look at the following FAQ (Frequently Asked Questions) Entry:

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…

---

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

[system]

The right hand side of the where has to be a constant. It can’t be a formula or variable. Could you use a filter? You could set a complex filter that would limit the data to the UserResponse.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Is there any way to solve my problem using VBA Macro.
Because, I want to use the UserResponse in the right side of the Where condition.

---

mmvraja (BOB member since 2004-02-26)

[system]

No need for a VBA macro, take a look at the link Dave provided to Reporter FAQ… it is all explained there very well if I may so.

---

Andreas (BOB member since 2002-06-20)

[system]

done this at Universe level

got current month (user response month) prior month and prior year current month

table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),-12) OR table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),0)  OR table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),-1)

code use it in
CONDITION or WHERE

Thx
Bhai

---

Bo_Bhai (BOB member since 2003-07-11)