Using AND , OR in same expression

[Koehn1345]

I am having a problem trying to filter a view by 2 expressions. This is the formula I am trying to use but not working
AND(([Supplier]=“6”)
OR([Origin]=“519”,[Origin]=“e9df84f5”))
I need the view filtered by 2 locations in ORIGIN Column and 1 in suppler column.

[Aurelien]

Hi @Koehn1345

Try that:

AND([Supplier]="6",
  OR([Origin]="519",
    [Origin]="e9df84f5")
)

In a row filter condition applied to a slice.
Make a view based on that slice.

[SkrOYC]

Koehn1345:

AND(([Supplier]=“6”)
OR([Origin]=“519”,[Origin]=“e9df84f5”))

Ordered:

AND(
  ([Supplier]=“6”)
  OR(
    [Origin]=“519”,
    [Origin]=“e9df84f5”
  )
)

You missed the , after "6")

[Koehn1345]

Thank you!!