Get CurrentIndex of FormulaMap loop?

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
$1.1
$1.1

So if I could get the CurrentIndex that the FormulaMap was processing (similar to CurrentValue), then I imagine using that in the multiplier equation. CurrentIndex would sort of be a reverse Nth().

Alternatively, is there a math equation for this type of scenario? Like a Log() or Power()?

Many thanks.

@Michael_McGreal

Please show the exact math for the calculation you want to perform inside FormulaMap().

Hi there Ander,

Thanks for your help.

Here is a video showing the exact math.
Text version for quick reading/skipping is timestamped in the video description.

Many thanks,
Michael

1 Like

@Michael_McGreal

I think you had the right idea: https://coda.io/formulas#Power

1 Like

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 :+1:

Michael

1 Like

Interesting project!