Select Expression

[BlakeHammond]

Hi

I have a select statement as follows:

SELECT(
Order List[Customer ID],
AND(
[Work Complete]<>true,
([Site Name]=[_THISROW].[Site Name],true)
)
)

This is under the initial value. But this returns the answers Customer1,Customer1. Does anyone know how to get rid of the second Customer 1.

Thanks

Blake

[WillowMobileSys · Accepted solution]

There is an options parameter for Distinct Only. Add the “, true” line inserted below

SELECT(
Order List[Customer ID],
AND(
[Work Complete]<>true,
([Site Name]=[_THISROW].[Site Name],true)
)
, true
)

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[BlakeHammond]

Thank you very much. You absolute LEGEND!!!