RE: 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.

ZalmanP Rookie Asked on March 15, 2021 in Reports.
Add Comment
2 Answers

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.)

Rookie Answered on March 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.