1 Reply Latest reply on Nov 21, 2018 11:17 AM by Patrick A Van Der Hyde

    How to determine position of values

    Alex Martino

      Hello. I have dates of Jan through Sepember by Product by month. I use this formula to get the average.

       

      AVG({ FIXED [Category], [Date]: SUM([Sales Volume])})

       

      I need to figure out how to identify the first date of a product (the first data that sales are > 0 for the period) and then use that to adjust JUST that specific month of data.

       

      I guess the idea would be to look through the period and determine the first point where that product has a value > 0 and then use that position and subtract from last day of the month to get the divisor.

       

      Additionally, I need to eliminate the months that have 0 out of the yearly daily average.

       

      Can someone help with this?