Hello,
I'm looking for assistance in refining my formula so that I can generate the necessary data for creating a chart.
Target state: The graph should ultimately roughly look like below:
Data required: I need 3 types of data points. I created a function on Xano solving 1 and 2 but I’m still stuck with 3
1) The number of years to reach an objective âś… (done)
2) The value at the end (e.g. year 2017= 1 million) âś… (done)
3) The value at the end of each year ❌ : I’m stuck here
To do this I tried to create an array to stock the data for each user’s graph basically. So I created an array, a counter and conditioned the formula with the value in the counter in a while loop. For some reason, this does not work.
Can somebody help me understand what I’m doing wrong? Thanks
