8 Replies Latest reply on Nov 16, 2018 1:27 PM by Hari Ankem

    Calculate average per category

    Alex Monteiro

      Hello,

       

      Need assistance on finding a formula to get the average per "CategoryLevel2ID".  I know that i will need a LOC formula but have been having problems to run correctly.

       

      Current formula: {INCLUDE [CategoryLevel2ID]:AVG([Total Time Open Display])}

       

      Capture.PNG