How do I update the formula to include even if blank? CASE WHEN{pricing.pricelevel}='Base Price' THEN {pricing.unitprice} ELSE NULL END. Just for a bit of background, I'm trying to pull the base price from the item record into a saved search for all currencies without having criteria of pricing fields set against it? We have items solely sold in USD and then other items that are sold solely in Euro and therefore when I'm looking at the current saved search I have, the base price is only populating for the amounts in the base currency rather than all hence formula above. May be another formula might be the answer... thoughts?

Put your IS NULL argument first CASE WHEN {pricing.price level} IS NULL THEN {pricing.unit price} WHEN {pricing.pricelevel} = ‘Base Price’ THEN {pricing.pricelevel} END

@AI1 Formula is showing error: invalid expression

Did you copy and paste my formula? It might have some spacing and punctuation errors. I typed it on my phone. Also not sure the fields I put in are applicable to your account. I was just trying to relay the overall outline or format to try. Maybe retype it in instead of copy paste