3 Replies Latest reply on Jun 29, 2016 12:08 PM by Tam Nguyen

    Display average calculation on specific weeks

    Tam Nguyen

      Hello,

       

      I've a question on how to display an average calculation on specific weeks.  The average calculation is based on current week and previous week.  Whereas the display is based on a Period End Flag = 'Y', which happens every 4 or 5 weeks (hiding weeks where Period End Flag = 'N'  won't do it because there's a new week added to the data every week).  Detailed question is inside attached workbook.

       

      Thanks!