Using the And

I am trying to write a condition using an and statement. When I write the function = Where (( month Key>=“June”) and (year = 2004)) I get incorrect results but if I only use one condition ie = Where (( month Key>=“June”) I get the correct results for that condition. Any thoughts?


lula123 (BOB member since 2004-04-13)


=<Assets> Where (( month Key>="June") and (year = 2004)) 

Try this:


=<Assets> Where (( <month Key> >= "June") and (<year> = 2004)) 

Donald Duck :mexico: (BOB member since 2004-07-29)

Doesn’t work :frowning:


lula123 (BOB member since 2004-04-13)

I ended up just writing and If…then Statement but why can’t I write it like the other?


lula123 (BOB member since 2004-04-13)

What do you get when you apply

=<Assets> Where  (( <year>= 2004)

. Do you still get correct results?
What is the data type for ?


mkumar (BOB member since 2002-08-26)

IT works if I do part of the formula


lula123 (BOB member since 2004-04-13)

Another option. Create a variable (say, ) with a formula like this:

= If <Month Key> = "June" And <Year> = 2004 Then "Y" Else "N"

Now write your formula to say:

= <Assets> Where (<Include> = "Y")

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)