I have a list that I’m running through FormulaMap() And I’m trying to apply a consecutive growth factor of 1.1 to every item in that list. So if each item in the list was $1, the output for 3 loops of FormulaMap would result in: $1.1 $1.2 $1.3 But at the moment, my current results are: $1.1 …

@Michael_McGreal I think you had the right idea: https://coda.io/formulas#Power [power_2019-01-08_1701]

Get CurrentIndex of FormulaMap loop?

Michael_McGreal January 9, 2019, 4:15am 6

Hi Ander,

It took me a couple tries to get to your answer. The sequence(), and order of operations in the Power() formula make this a superb solution.

Many thanks my friend

Michael

1 Like

Topic		Replies	Views
Formula Map - Refer to the NextValue after CurrentValue	5	684	August 16, 2022
CurrentValue in Named Formulas and FormulaMap	9	5122	October 15, 2021
Simulate a For Loop (Reference position inside FormulaMap) Tips and Hacks	12	9033	January 26, 2022
Case where using currentvalue breaks the formula results Bugs	7	641	March 21, 2024
CurrentValue in a an AddRow() in a FormulaMap()	8	635	September 5, 2022