Hello all, I need some assistance with a saved search: In a report showing sales of an item, I only want the price to appear for the preferred vendor. Under the criteria, I am using formula(numeric) case when {vendor} = {othervendor} then 1 else 0 end with greater than or equal to 1 but when I submit the search, it gives me an error: Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.

Is your search an item search or a transaction search?

Transaction

You'll want to use the item join since the fields referenced in your formula are on the item record and not the transaction record. Try {item.othervendor} instead of {othervendor}.

Oh brilliant, thank you!