Hello All,
We have requirement where request may have flag values "Y", "N", ("Y"&"N" )
In case if one request have flags both "Y" and "N"
We only have to consider Y and filter out N.
My approach was to get list of request which are getting duplicated. I have created 2 different variables where one variable will give list of req with flag N and 2nd variable with flag Y.
I want to get only the common request present between the two variable.
= If ([Request_Y]=[Request_N]) Then [PRJ].[Request] Else "Hide"
which is not giving me common values.
Can anyone help me with this?