Given the choice (thanks) I went back to your initial (simple) suggestion.
One problem however--1 of the years has negative inflation. When that value is included in the string it turns the product into a negative number instead of reducing the preceding cumulative total by that year's negative inflation?
|