Enumlist addition and Subtraction

[Jonathan_S]

Good Afternoon All,

Little head scratcher. I know exaccly what I need, Just dont know how to implement.

See expression below,
Expression will be placed in a valid if,

Select(Production Scheduling [Line #], and([_Thisrow].[Plant #] = [Plant #], [_Thisrow].[Production Type] = [Production Type], [In Production]))

The [Line #] seen above in Bold is of Type Enum List.

I need to Add all the [Line #]s together and than Filter out all the duplicates.

Its just this entire Enumlist thing still bothers my brain here and there.

[Steve]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Jonathan_S]

lol. Sorry Steve, I looked at this document first thing

Since these are in Enumlist format is it looking at the individual items in each [Line #] ?

This select could bring this up.
The values of each of the items in each Cell/Value would be the ID of each item for for demonstrative purposes Ive put in the Label.

[Line #1, Line #2]
[Line #2, Line #3]
Line #3]
Line #1]

I would Need the Output to be a list of just 3 IDS, Line #1, Line #2, and Line #3.

[Steve]

Ah! Sorry.

(SPLIT(SELECT(...), ",") - LIST(""))

[Jonathan_S]

SPLIT(
Select(Production Scheduling[Line #],
and(
[_Thisrow].[Plant #] = [Plant #],
[_Thisrow].[Production Type] = [Production Type],
[In Production]
)
), “,”) - LIST(SPLIT(
Select(Production Scheduling[Line #],
and(
[_Thisrow].[Plant #] = [Plant #],
[_Thisrow].[Production Type] = [Production Type],
[In Production]
)
), “,”))

??

[Steve · Accepted solution]

Nope.

SPLIT(
  Select(
    Production Scheduling[Line #],
    and(
      [_Thisrow].[Plant #] = [Plant #],
      [_Thisrow].[Production Type] = [Production Type],
      [In Production]
    )
  ),
  “,”
)
- LIST("")

Literally, minus, LIST, open parenthesis, quote, quote, close parenthesis.

[Jonathan_S]

Thank you,

Starting to Use Enumlists more and more, but they add a whole other level to the expressions

[Jonathan_S]

How Does - LIST("") Work?

[Steve]

help.appsheet.com

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.

[MultiTech]

Steve:

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren’t also in the second.

More like list MAGIC!

---

But for any situation when you’re wanting to remove the duplicates from a list, I would suggest:

UNIQUE()

help.appsheet.com

UNIQUE()

Unique items in list