Can someone tell me how I'm supposed to use table variables in the formula editor? Say I have a variable x with value 3, I open the editor and create a column with value 2*x. In the editor the preview nicely shows that this would return values of 6 for the entire column. However, after applying it this is not the actual result but I'm getting a Name unresolved error instead.
This is not intuitive at all. I have been able to get it to work in the past but every time I'm struggling again.
Additionally it would be nice to just have a list of the columns and table variables to pick from while in the formula editor.