Create Variables from a table

[PBE]

Hi, I would like to create variables from a table which relate to the row number and a specific column.

There are two columns WL and ST. Each variable will be numbered in relation to Row No. As shown below, for example:-

For Row 1 the two variables will be WL1 and ST1. Where WL1 = 21 and ST1 = 1680

For Row 2 the two variables will be WL2 and ST2. Where WL2 = 156 and ST2 = 1680

and so on up to a maximum of 30 rows.

I will then use the variables in different formulas such as

Formula 1 = WL1 + ST1

Formula 2 = Formula 1 + WL1 - ST1

Is it possible to extract a figure in a column and relate to row no. such as WL1 = 21 or ST1 = 1680?

I hope this makes sense. Any question let me know.

Thank you for any help in advance.

PBE

[v-zhangti · Accepted solution]

Hi, @PBE 

You can try the following methods.

New table:

New table = ADDCOLUMNS('Table',"WL Variable","WL"&[Row No.],"ST Variable","ST"&[Row No.])

Column:

Formula 1 = IF([WL Variable]="WL1"&&[ST Variable]="ST1",[ST]+[WL])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PBE]

Thank you that worked

[PBE]

Hi @v-zhangti 

Thanks for this, it looks good. I'll try it out and let you know how I get on.