Excluding null values

[steverdan]

I have tale with a vendor column for all operations that are done by outside vendors. These are the exceptions to the rules, but they are what I'm looking for. I want to use that value when not null to set up a formula to gather the value of orders at the vendors. How do I get it to look for these values and then look at a status for these operations which is another field and then for the ones at vendors, then get the dollar totals?

[DellSC · Accepted solution]

You need to figure out how your tables link together - in other words, what are the joins you need to create in the Linking tab of the Database Expert when you add the tables to your report.  You would then use something like this in the Select Expert:

not IsNull({MyTable.VendorColumn})

This will get you all of the non-null vendor rocords.

-Dell

[former_member205840]

Hi Daniel,

Also you can add one more condition to check if that column value can be a blank space :

not IsNull({MyTable.VendorColumn}) or {MyTable.VendorColumn} <> '  '

-Sastry