Skip to Content
0
Jan 19, 2023 at 09:36 AM

Get common data values present in the 2 different variable in BO

75 Views

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?