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.
Add Comment
2 Answer(s)

Change formula to  CASE WHEN Available < 40 THEN 0 ELSE On Hand - Committed END perhaps?

Intermediate Answered on March 15, 2021.
Add Comment

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor