1 Reply Latest reply on Jul 13, 2016 3:12 PM by Patrick A Van Der Hyde

    Average Inventory in custom period

    David Heinz

      Hey guys,

       

      I need to calculate the average inventory in a specific time period (for instance last week).

      The time period should be adjustable, so the user should be able to change it to last months, the week before etc.

       

      I'm pretty sure, there is a simple solution for that, but I'm not getting it right now...

       

      Best, David

        • 1. Re: Average Inventory in custom period
          Patrick A Van Der Hyde

          Hello David,

           

          You could filter all of the data such that it only includes the data for the time range of interest and then run an avg() calculation.  Depending on the Dimensions in the view, it may be easier to utilize a LOD calculation or a Table calculation.  If you can share a workbook with a sample of your data setup, it would be easier to assist you. 


          Patrick