So I am stuck on a Formula in a saved search, we have a saved search that pulls the inventory on hand for each of our warehouse, that gets sent to our trading partners via our edi connection. We have 1 column for each of our 3 warehouses. I have been asked to add something in to zero out an item in the other 2 warehouse if we have qty in 1 specific warehouse. Example Item XX, we have stock in W1 and W3, but since we have stock in W3 which we are trying to deplete we want W1 to go to 0. I need to figure out a way to look at W3 and if there stock, W1 needs to be 0, I have tried a case statement mixed with Decode and it doesn't seem to work. Any suggestions or ideas.

Not really possible since you can't group first, then make formulas which is what you need in the case. You could make item level fields for each warehouse that are based on a calculated search, then have the saved search reference those? Would work well if you didn't have many warehouses

Also posted in #C298P0BCK and answered there: https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1684171905472479 tl;dr: It's a summary search, so can use a "Minimum" summary type with a formula that populates the 'W1' column with zero/null depending on the stock available for the 'W3' location