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)