BusinessObjects Board

Dynamic Data bucketing using formulas

building reports desktopintelligence
#1

Good day all,
I have a serious problem using BO 5.1.3 It seems that the formula I’m using does not like one of my variables that I’m passing it.

I want to obtain a window of data from the query that lets me change the window on the target window on the fly.

For Example:
=<US Amt(Global)> Where (<Year(Global)>= “2004”)

Will bring the correct window of data.
Now if I want to make that formula dynamic and place the year in a variable it does not let me, see below:

=<US Amt(Global)> Where (<Year(Global)>= <Var_TargetYr>)

I have tried changing the format of the var_TargetYr as shown below
“2004”,2004,FormatNumber(2004,“0”)
and nothing works :reallymad:

Any suggestions
Thanks.
-Quick

quicka2 (BOB member since 2005-04-13)

#2

Try doind this instead


=if (<Year(Global)>= <Var_TargetYr>) then <US Amt(Global)> else 0

Thanks
Bhai

Bo_Bhai :us: (BOB member since 2003-07-11)

#3

Also try a look at this FAQ Reporter entry…

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

#4

Thanks guys, it seems like I’m doing something wrong because it still does not work. do the variables have to be the same type i.e. Dim or Detail?

Thanks

quicka2 (BOB member since 2005-04-13)