Referencing a column

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

0 5 208
5 REPLIES 5
Top Labels in this Space