Select with multiple conditions

I have created a virtual column with select().

below is the select statement…

SELECT(CustItemCode[Party Item Code],AND(([Item Code]=[_THISROW].[Item Code]),([Customer Code]=[_THISROW].[Customer Code])))

the above query only checks for the first condition.

What could be the reason?

https://community.appsheet.com/search?q=@steve%20quirk

1 Like

Thanks. Will check

1 Like