Can anyone help me with a formula i have in a saved search? My saved search is looking at Sales Order line items (main Line = F). Basically I want a column in the search to display (amount of line/count of fullfillments. Ex: line item is 20,000. That particular line item has 2 fulfillments tied to it so the column would display 10k (20,000/2).. I have this formula but it is giving me an invalid expression: SUM(CASE WHEN {quantityshiprecv} > 0 THEN {grossamount}/nullif(COUNT(DISTINCT({fulfillingtransaction.internalid})),0) ELSE {grossamount} END)