2 Replies Latest reply on Aug 2, 2013 9:26 AM by .Yann Treguier

    How to calculate a running avg without including hidden data on the partition?

    .Yann Treguier

      My goal is to calculate the sales running avg only based on the visible partition not the entire partition.  In the example I attached, I am only showing the last 10 days.  My moving average is correct even for the first data point (12/22/2013) as it is looking back 2 days and able to pick on 12/20 and 12/21 sales.  However, for the running avg, I don't want that behavior to take place.  The running avg on 12/22 should be $9493, it should be $11,149 and so on.  I know it is probably a matter of using a combination of LOOKUP() and FIRST() but I can't figure it out.

       

      Thanks!