BusinessObjects Board

Litteral and variable

building reports desktopintelligence
#1

Hi,

I have in my repport 3 amounts A1, A2, A3 and 3 dates (2003,2004,2005). I would like to know :

why when I write
= where ( = “2005”) it runs ( I get the amount A3)

and why I write
= where ( = Max() ), it does not work ???

:confused: :confused: :confused:

Thanks for your help.

fgerbaud :fr: (BOB member since 2004-12-11)

#2

Because That’s The Way It Works :slight_smile:

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

#3

I think that it needs to know what Max of year you are talking about. What I do is (temporarily) place a cell in portion of report that you want Max year for (e.g. all of report or section) and place Max formula in the cell…then click on cell and go to Data/Define as Variable. Name it and tick the Define in Context box. THEN use that variable to compare with your year (and you can delete the cell also).

AHarper (BOB member since 2003-01-24)