0 Replies Latest reply on Oct 12, 2018 9:42 PM by Alex Martino

    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?