BusinessObjects Board

VAriables not working in WEBi XIR2

building reports webintelligence
#1

Hi,

Following variables are not wokring in WEBi XI R2. IF I pull these variables I am getting #ERROR.

Measure variable1:
=[Amount1] Where (([DATE1=[DATE2]) AND (Amount2>Amount3))

Amount1 is an Universe Object, Amount 2 and Amount3 are measure variables.

Measure variable2:
=Sum([Var1]) Where (([DATE1=[DATE2]) AND ((Var2=0 AND Var3=1) OR (Var2=1 AND Var3=0)))

Var1, Var2, and Var3 are measure variables.

Jack (BOB member since 2007-10-25)

#2

See this oldie but goldie: Why do I get an error when I try to Sum() Where ( > 2000)?

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