Formatting based on two columns
any advisce how I should go about combining values from two columns?
Basically, I have one column based on a custom field called member value which outputs either Norm (normal customer) and HV (high value customer) like: if((incidents.c$membervaluepriority >= 80),'HV','Norm')
Then I have a column that outputs the group the incident is assigned to (accounts.group_id).
What I would like to achieve is a column that combines these two in the following way: output 1st column, but if the group equals selected groups (3 out of many) change the output from Norm of HV to VIP.