Select Expression

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

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
)
3 Likes

Thank you very much. You absolute LEGEND!!!