Report Column Logic
I have a custom report that lists items and the item’s available quantity is one of the columns. It uses a formula : On Hand – Committed. It is working ok.
However, I need to change it so that when an item has < 40 available it should show 0 in the available column. Is there any way I can have this logic built into the report?
Any ideas would be most welcome.