Forum Discussion
Create Variables from a table
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
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.
3 Replies
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.
