Divide two values in a saved search with SQL

I created a saved search that used line items from invoices to pull line item detail. I am creating a report that groups by item pulling the Quantity billed, and then the item quantity on hand. I can pull these two values individually, however I am trying to see how mnay months of inventory we have on hand by dividing quantity on hand from the average quantity billed. I have tried a million different ways of makin the formula. Can anyone help me figure out what I am doing wrong?

The current formula is:

NVL({item.quantityonhand},0)/NVL(sum({appliedtotransacation.quantitybilled})/2,0)

(the /2 is because we pulled 2 months of sales and had to find the rate of sale per month)

Rookie Asked on May 4, 2022 in Saved Searches.
Add Comment
1 Answer(s)

Could you explain what is going wrong currently?

Are you able to share any screenshots?

Intermediate Answered on May 17, 2022.
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   Limebox   Become a Sponsor