help in filter function.

[anonymous008_G]

Hi,

I have below dataset where using filter function i want to instruct alteryx to from recordID 16 onwards filter the value as derivatives, Long, Short and cells containing FX from sector column. 

I have tried below code but this is not working. it is filtering all the values from record ID 1 to 23 but i want specifically filter from RecordID 16.

Can someone please help.

RecordID>= 16 and [Sector] = 'Derivatives' or [Sector] = 'Long' or [Sector] = 'Short' or Contains([Sector], 'FX')

RecordID	Sector
1	FX-D
2	FX-C
3	FX-B
4	FX-A
5	Short
6	Long
7	FX-A
8	FX-B
9	FX-C
10	FX-D
11	Long
12	Long
13	Long
14	Long
15	Long
16	Derivatives
17	FX-A
18	FX-B
19	FX-C
20	FX-D
21	Short
22	Long
23	FX-A

[Deano478 · Accepted solution]

Hey @anonymous008_G give this modified filter expression a try:

[RecordID] >= 16 AND ([Sector] = 'Derivatives' OR [Sector] = 'Long' OR [Sector] = 'Short' OR Contains([Sector], 'FX'))

[anonymous008_G]

@Deano478 -- this works. thanks a lot