1 Reply Latest reply on Sep 5, 2018 4:53 PM by Hari Ankem

    Aggregate Compounded Return

    Austin Butorac

      Hello,

       

      I am having trouble creating a running aggregate product.  I have a data set with projections quarterly and different categories.  Every formula tried either gets a circular reference error or an error with mixing values and aggregate values.  I have attached a sample data set.  The goal is to calculate the compounded return in column E.  See below of a screenshot of the data:

       

       

      Any help would be greatly appreciated! Thanks!