Select with multiple conditions

[Rahul_Sanghavi]

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?

[Steve]

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

[Rahul_Sanghavi]

Thanks. Will check