If And Statement

building reports desktopintelligence
1

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)

2

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

Secondly, in what way is it not working?

3

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)