I have been tasks with adding a calculated measure for average inventory. The requirement is that whatever date range is selected that the inventory on the first day of the range and the last day of the range is taken and divided by 2.
I can do the calculation in script, but when I copy that calculation into a calculated measure in the cube I am not returning data. At this point I am down to just trying to get correct starting inventory number to show as a calculated member. This returns the value correctly in query window, but not when in a calculated measure.
HEAD({(descendants([Date].[All],,leaves),[Measures].[Inventory At Cost])},1).ITEM(0)
Thanks for any help