I have an inquiry that I’m working on and struggling with the formula. I either get the “divide by zero error encountered” message, or syntax error.
I need to take this formula already set in the inquiry, (this gives us our Average Inventory)
and divide it by: (This gives us the Sales COGS)
=([INItemCostHist.FinPtdQtySales] + [INItemCostHist.TranPtdQtyAMAssemblyOut]) * [INItemCost.AvgCost]
This final number that I am attempting to find is the inventory Turns for my Supply Chain manager. He can achieve this in excel, but I wanted to try and give this to him in the report.
I have tried many different ways to write it and sometimes it says it validates, other tries it doesn’t. I did find another post on in the community that talked about the divide by zero error and tried different ways of writing the code similar to that result but haven’t gotten it to work.
Does Acumatica allow this type of formula in a GI?
Thank you for any pointers.
Best answer by BenjaminCrismanView original