I have a list of variables. I want to group certain variables under certain groups.
For example, I have a list of variables: a, a, b, b, b, b, c, d, d, e, e, e
I want to sort the variables:
- a, b and c as "control".
- d and as "low spec"
I thought I could use the if and or functions from the formula editor as shown below but it doesn't seem to work
If( :Column 74 == ("a" | "b"),
"control",
"low spec"
)