I am using a repeating group to generate data for a graph.
One of the important calculations in the RG is a recursive equation, that is, each row depends on the answer in the previous row. It’s really easy to do in an Excel spreadsheet, simple as (Row 2) (Collum 1) = (Row 1) (Collum 1) + 1.
How do you access an input in the previous row? I can do it using List Calculator but it’s very wonky. I hope there is a better way.
When are the entries created for the repeating group? Usually you would do it then. Otherwise maybe you could use current cells index within the repeating group assuming you want the first entry to always start with 1.
Yes, it uses dynamic data with user input. The problem is the financial equations build on the result of the previous row. The way I have it with the list calculator works mostly, just gives me some glitchiness I’m trying to solve.