How do i create a calculated field to filter some names in a column into a new column?
I want to achieve this;
a, b, c, d, e, f are different reports under various categories and are under one field. I want to separate them into their various categories giving it a new field.
I used the syntax: report_category contains (‘a’,‘b’), ‘category_one’. That is if the report category has the following names, call it a new field category one
something like that?
ifelse(in({Report},["A","B"]),"Cat1",in({Report},["C","D"]),"Cat2","Cat3")
BR
Hello @Jane_Onwuchekwa !
Was @ErikG 's suggestion helpful, and if so could you mark their comment as a solution to help the community?
It has been some time since we have heard from you but would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived.
It’s
ifelse(contains({report}, "A") or contains({report}, "B"), "Cat1", ifelse(contains({report}, "C) or contains({report}, "D"), "Cat2", "Other" ) )
1 Like