6 Replies Latest reply on Jul 27, 2012 6:28 AM by Joseph Pirraglia

    Is There A Way To Calculate The Weighted Average Life (WAL) Of Dollars For A Time Series? A Sumproduct?

    Joseph Pirraglia

      Using the attached tableau workbook – is there a way to calculate the weighted average life of the dollars? I would think of this in Excel terms as:

       

      Sumproduct(Period Index * Dollars)/Sum(Dollars)/12

       

      I get the message “cannot mix aggregate and non aggregate arguments to function” when trying to set this up in “Sumproduct”. How do I get past this issue?