Select() Function Error

AppSheet AppSheet Q&A
, , ,
1

Hi,
Why this function is not worked in the price types column please help.

SELECT(Selling Price List[PRICE],[_THISROW].[SKU] = [Item SKU Code], TRUE)

The expression is valid but its result type 'List' is not one of the expected types: Price

Capture.PNG
Capture.PNG1428×420 27.3 KB

2

Enclose your SELECT() within an ANY(), like this:

ANY( SELECT(…) )

2 Likes