BusinessObjects Board

If And Statement

Hi,

Trying to create a variable something like:

If( Table 1[columnA] >= 0 and Table 1[columnB] <= 30 then “pot1” else “NA”)

but for some reason is not working, what am I doing wrong?

Thanks in advance,

Any help and all help is very much appreciated


vitordf59 (BOB member since 2015-08-28)

Firstly, are you on 6.x Desktop Intelligence or Webi?

Secondly, in what way is it not working?

Query names need to be bracketed too:
If( [Table 1].[columnA] >= 0 and [Table 1].[columnB] <= 30 then “pot1” else “NA”)


joepeters :us: (BOB member since 2002-08-29)