I need to filter with these 2 conditions :
AND( [in_use] = TRUE , [storage_area] = “Bar” )
From what i understand, it doesnt work because [storage_area] is a enumlist type variable.
I have spent half my afternoon on this … can somebody help please?
Thanks !
Try:
AND( [in_use] = TRUE , IN( “Bar”, [storage_area] ) )
See also:
Thank you Sir, it works.
Meanwhile, i managed to work it out this way :
AND( [in_use] = TRUE , CONTAINS([storage_area] , “Bar”) )
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |