BusinessObjects Board

Combining where function and detail

building reports desktopintelligence
#1

Hi All,

I’m using BO 6.1, no access to Universe. Here’s my problem:

I have a Detail variable called which displays the previous accounting year (this is done through a Userresponse function).

I also have a Revenue column with the formula = where (=“2008”).

What I want to do is something like = where (=). When I try that I get a Syntax Error.

I do not want to create a new Query as I have too many already. Does anyone know how I can achieve the above?

Many thanks

farigust :uk: (BOB member since 2006-08-18)

#2

Hi, please see this FAQ for input on your question. :slight_smile:

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