same expression for same data, different result in vitrual column and bot

[Andy_strathmore]

Hi Everyone,

I have been confused by 2 different results for same data and same expression.

Here is the expression

"isnotblank(
filter(
"Product_Locations",
and(
([_thisrow].[product] = [product]),
([_thisrow].[location] = [location])
)
))" 

This expression is checking in the particular location has a particular product or not.

If yes, return Y, otherwise return N.

For this expression, in vitrual column, it return N as following Image.

Here is where I wrote it in the branch

For this bot, I checked it in bot which showed Y.

I am very confusing. May anyone help me!

[Steve]

Try this instead:

isnotblank(
  filter(
    "Product_Locations",
    and(
      ([_thisrow].[_RowNumber] <> [_RowNumber]),
      ([_thisrow].[product] = [product]),
      ([_thisrow].[location] = [location])
    )
  )
)