I have a table with columns named [Deposit 1], [Deposit 2], … , [Deposit 9].
The number of Deposits will vary in each row i.e., some rows will only have Deposits 1-3, others will have 1-6.
I also have a column named [Number of Deposits] where the user tells me how many deposits the row will have i.e., 5.
Is there a way to create an expression that dynamically references the LAST deposit… basically, I want to create an expression that dynamically references the last deposit, [Deposit [Number of Deposits]] ← if the [Number of Deposits] was 6, this would become a reference to [Deposit 6], if the [Number of Deposits] was 8, this would become a reference to [Deposit 8] and so on…
Thanks
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |