Solved: Filter ref - Page 2

Cannone_Cannone · 08-13-2019 02:45 PM

Hi everyone
I have a “MAINTENANCE” table with a column named “N.S” that refers to a “GSE” table.
In the table “GSE” .- (column “N.S” numbers), (column “STATE” inoperative).
In the “MAINTENANCE” table, how can I display only the numbers in the “N.S” column that are inoperative
In the “GSE” table?
thank you

Steve

For the Valid If expression for the N.S column of the MAINTENANCE table, try:

SORT(
  SELECT(
    GSE[N.S],
    AND(
      ISNOTBLANK([STATE]),
      ([STATE] = "inoperative")
    ),
    TRUE
  )
)

View solution in original post