I'm trying to pull the quantity on hand (QOH) from a table that contains QOH per year per period. The set analysis below has multiple modifiers to filter the QOH for the year and period. I'm not getting errors, but the result is 0 (zero). I'm not sure where my set expression is failing. Any assistance would be very much appreciated.
You are correct in what you are saying. The full purpose of the expression will be to calculate inventory turnover. I need to first compute the average inventory for the period - (beginning inventory + ending inventory)/2
Now that I have the current period working, I need to calculate the beginning inventory which is the ending inventory from the previous period using -1 in the modifier.