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 to show numbers when they are negative. I do not want to show positive numbers.
How do I do this?