Scenario
Average Cost under the Purchasing/Inventory tab of an item displays null if the total quantity of the item is 0. The computation of Average Cost is Total Value / Total Quantity on Hand.
Solution
For those Items that have blank/null value on it’s Average Cost, the values are computed per the formula below:
Total Value = 0.00
Total Quantity = 0
Total Value/Total Quantity=0.00/0 = Error
Note: Instead of showing an error, the system uses Null If function and returns blank for the Average Cost,=0.00/nullif(0,0) = returns blank if the divisor is equal to zero.