LinkedIn
Twitter
Hi
I want to have a comparison in a "Valid if" field, where I want to filter all the rows from List A that has an equivalent in List B, but not necessarily the other way around. Let's say
I tried a few formulas and ideas in a Virtual Column and came up with this:
COUNT([AGREGAR_MEZCLA].[LIST_1])-
COUNT(INTERSECT(
LIST_2),[AGREGAR_MEZCLA].[LIST_1]
))=0
Basically I am counting the elements of list 1, and counting the shared elements of both lists; if the result is 0, it is fine; else it should not appear in the Valid If field. However when I paste that formula in the "Valid If" field of the other column and enclose it in a "Select" to get the desired Valid list, it gives me an error:
INTERSECT does not accept a list of list.
How can I avoid that and keep the basic formula? or maybe a better solution?
