system
August 2, 2004, 4:47pm
1
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)
system
August 2, 2004, 4:54pm
2
=<Assets> Where (( month Key>="June") and (year = 2004))
Try this:
=<Assets> Where (( <month Key> >= "June") and (<year> = 2004))
Donald Duck (BOB member since 2004-07-29)
system
August 2, 2004, 5:19pm
3
Doesn’t work
lula123 (BOB member since 2004-04-13)
system
August 2, 2004, 5:20pm
4
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)
system
August 2, 2004, 5:25pm
5
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)
system
August 2, 2004, 6:52pm
6
IT works if I do part of the formula
lula123 (BOB member since 2004-04-13)
system
August 2, 2004, 7:19pm
7
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 (BOB member since 2002-09-19)