Topic: Conditional Filtering Posted: 22 Apr 2012 at 10:35pm
I super need your help!
I want to filter based on the ff:
NumberOne is equal to either one of the following: 100, 200, 300, 400
OR
NumberTwo is equal to either one fo the following:100, 200, 300, 400
AND
FieldB is equal to 888
AND
DateOne is in last full month.
i have this so far:
{A.FieldB} = "888"
and
{A.DateOne} in LastFullMonth
and
{A.NumberOne} in [100.00, 200.00, 300.00, 400.00]
or
{A.NumberTwo} in [100.00, 200.00, 300.00, 400.00]
It's not working :'( i dont know how to do "OR" in filter.
Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Posted: 22 Apr 2012 at 11:21pm
{A.FieldB} = "888" and {A.DateOne} in LastFullMonth and ({A.NumberOne} in [100.00, 200.00, 300.00, 400.00] or {A.NumberTwo} in [100.00, 200.00, 300.00, 400.00])
Enclosing the OR statement in brackets should fix it.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
