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?