BusinessObjects Board

#CALCUL

building reports desktopintelligence
#1

Hello,

I have a board like this :


01/11/2003 5 A 5
30/10/2003 10 A 10
08/10/2003 20 A 20
where is if <=inDate(“30/10/2004” ,“dd/mm/yyyy”) then <Vol: Nb vols>

If I delete the variable from the board i have an error #CALCUL instead of 15 (5+10 for the hall A)

35 A #CALCUL

I could i resolve this error ?

thanks

please find the report in attachment

florence
error.rep (95.0 KB)

mercier (BOB member since 2003-02-10)

#2

i resolved the problem with 2 variables :

= if <= indate(…) then “yes” else “no”

= where =“yes”

mercier (BOB member since 2003-02-10)

#3

Simple answer:
You must leave in your block if you are referencing it in another variable using IF… THEN…

Work around (one you already found):
Use the WHERE clause instead with a flag on DATE, see this Reporter FAQ entry.
Drawback:
As of WebI v6.5.1 there is still no WHERE clause for variables I believe.

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

#4

True, but I provided a work-around in my “Best of Variables” presentation at the conference this year. To replicate this from full client:

Sum<X> Where (<Y> = "Constant")

do this in Webi

Sum(If([Y]="Constant";[X];0))

In my testing so far that has seemed to work, and [X] does not have to appear in the block for the calculation to be performed. It does, obviously, have to be in the query result set.

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