Hello,
I have one report in which is one column in which all the values should be picked from another list. I would like to make a check field, which would show e.g. 1 (or sum of 1s) if in the column is a value, which is not in another list. Here is an example.
Column1 (unique values)
A
B
C
Column2 (consolidated inputs)
A
B
A
B
A
B
C
D
I would like to display 1 if in Column2 is a character that is not listed in Column1 or zero if all characters in Column2 are in Column1 as well.
Do you have any idea how to do it, please?
I have one report in which is one column in which all the values should be picked from another list. I would like to make a check field, which would show e.g. 1 (or sum of 1s) if in the column is a value, which is not in another list. Here is an example.
Column1 (unique values)
A
B
C
Column2 (consolidated inputs)
A
B
A
B
A
B
C
D
I would like to display 1 if in Column2 is a character that is not listed in Column1 or zero if all characters in Column2 are in Column1 as well.
Do you have any idea how to do it, please?