How to gather all the other related column values but exclude the value in this THISROW?

[wenli]

Hello community members,

When using the SELECT function, it will gather all the related column values based on the [_THISROW].

Is there anyway to gather all the other  related column values but just exclude the value in the same row of  [_THISROW]?

Thanks.

Wang Wenli

[Joseph_Seddik · Accepted solution]

SELECT(table[someColumn], conditions) - LIST([_THISROW].[someColumn])

____

List Subtraction | AppSheet Help Center 

[Joseph_Seddik · Accepted solution]

SELECT(table[someColumn], conditions) - LIST([_THISROW].[someColumn])

____

List Subtraction | AppSheet Help Center 

[Aurelien · Accepted solution]

Hi @wenli 

in addition to @Joseph_Seddik 's suggestion, here is a useful documentation: please have a look to the last paragraph:

https://help.appsheet.com/en/articles/961274-list-expressions