Select Expression

[anonymous]

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]

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
)

[anonymous]

Thank you very much. You absolute LEGEND!!!