+ Start a Discussion
BillFBillF 

Excluding id's with blank data

I am using an OR clause to filter my data.  I need to put in two values along with a way to exclude blank values.  My query says SFDC field <> to Value1,  Value2. How do I add a third value to that statement and have the query filter out blanks also?  I have tried using, " ", Null and just a space.  So far no luck.

 

 

BillFBillF

Figured it:

 

It requires the same field twice.

 

SFDC Field <>

SFDC Field <> value1,value2

BillFBillF

Whoops that didn't work - it looks like it put an and between the two exlucdes :(

flewellsflewells

This should work:

 

SFDC Field <> ,value1, value2

 

OR

 

SFDC Field <>

SFDC Field <> value1,value2

 

then add filter logic so it reads:  1 or 2 (instead of the default 1 and 2, as you mentioned in your later post)

 

 

BillFBillF

I tried this option:

 

SFDC Field <> ,value1, value2

and it does not see the null value.

SFDC Field <>

SFDC Field <> value1,value2

 

I'm sure this would work, but I can't see where to change the AND to an OR in the Query.  I just see the values list out in columns in Excel?

flewellsflewells

My bad, I only now see you posted this question specifically for Excel Connector.  My response is only applicable to Reports within Salesforce.com.

jroyaltyjroyalty

You said you had tried using " ", did you try ""?

rpr2rpr2

I just tested by sandwiching the null in the middle with two commas and it worked that way.  I didn't try putting it at start of end.

e.g. value1,,value3