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.
Rookie Asked on March 15, 2021 in Reports.
Change formula to
CASE WHEN Available < 40 THEN 0 ELSE On Hand - Committed END perhaps?
Thanks so much for your response. Can I use “Case” formulas in Reports? I thought that was only in Saved Searches. ( Sorry new NS user here.)