Home

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
Cancel
2 Answer(s)

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

Cancel
Intermediate Answered on March 15, 2021.
Add Comment
Cancel

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

Cancel
Rookie Answered on March 15, 2021.
Add Comment
Cancel

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   Limebox   Become a Sponsor   Become a Sponsor