How to Show Difference between two Inventory Numbers Through Saved Search Case When Expression?
I need to create a result in a saves search that shows me the difference between two inventory number. In Excel, I would type: =if(sum({preferredstocklevel}-{quantityonhand})<0),(sum({preferredstocklevel}-{quantityonhand}),"") I believe I can use a CASE expression, but cannot determine the syntax. To be clear, I only want…