Hi,
I am attempting to create a quarterly time-series index that starts with 100. In Excel, I can start by multiplying 100 by a known factor and repeat row by row
where each index value is then multiplied by the next quarter's known factor:
I have tried to do the same with a Multi-Row Formula and Generate Row but can't get it to iteratively loop through each quarter(row/record), perform the calc by starting with 100 in [tot_start} look for the known factor [tot_start] in the next +1 time period field [tret], in this case 1.0225 for the first calc, take that calculated value of 102.25, loop to the next known factor 1.0438 and multiply it by the previous result of 102.25 and then keep going through the entire time-series.
Thanks for any help and insight you can provide!
Solved! Go to Solution.
Awesome! Thank you so much this works perfectly.
I overcomplicated the conditional logic when I was initially using the Multi-Row tool and formula.
Have a great day!